Re: Detecting priviledges of role
From: N.Prabhakar <n_prabhakar_at_hotmail.com>
Date: 2 Dec 2001 01:15:13 GMT
Message-ID: <01c17ace$dfa0e600$510e0a3d_at_default>
Date: 2 Dec 2001 01:15:13 GMT
Message-ID: <01c17ace$dfa0e600$510e0a3d_at_default>
hi there
get all the role names from DBA_ROLES
go to TABLE_PRIVILEGES and see what is given to this role
regards
NP
Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in article
<9uavjq$1klv$1_at_as201.hinet.hr>...
> How to programmatically (in Oracle Form - Developer6i) detect if one
> role has some priviledges? For example i'd like to be able to detect if
> role 'AAA' has priviledge 'SELECT' on table 'BBB' in shema 'CCC'.
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
>
>
Received on Sun Dec 02 2001 - 02:15:13 CET