Re: Detecting priviledges of role

From: Sean P. Goggins <sgoggins_at_visi.com>
Date: Sat, 1 Dec 2001 14:33:33 -0600
Message-ID: <3c093e9d$0$79563$7f8943f3_at_newsreader.visi.com>

Just about everything related to roles can be found in these views. (connect in SQL*Plus as a user with DBA Privileges)

DBA_ROLES
DBA_ROLE_PRIVS

ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
ROLE_TAB_PRIVS

SESSION_ROLES
USER_ROLE_PRIVS For your question, I would start with the query below.

 select role, table_name, privilege from role_tab_privs where owner='CCC';

"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news: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 Sat Dec 01 2001 - 21:33:33 CET