Home » SQL & PL/SQL » SQL & PL/SQL » What Privilege are Recd
What Privilege are Recd [message #250000] Fri, 06 July 2007 14:22 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Hello everybody

I want to know how do you check that what privs and what roles are you assigned,

I have tried user_tab_privs_recd/all_tab_privs_recd but looks confusing to me,


Thanks in advance


Re: What Privilege are Recd [message #250003 is a reply to message #250000] Fri, 06 July 2007 14:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dba_role_privs
dba_sys_privs
dba_tab_privs
dba_col_privs

Search on Reference manual for these.

Regards
Michel
Re: What Privilege are Recd [message #250005 is a reply to message #250000] Fri, 06 July 2007 15:09 Go to previous messageGo to next message
abdou_ci
Messages: 5
Registered: May 2007
Location: I
Junior Member
Hi
I don't anderstand your reply.
but telle me if it's possible to do a select after my begin?
Re: What Privilege are Recd [message #250006 is a reply to message #250005] Fri, 06 July 2007 15:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
abdou_ci wrote on Fri, 06 July 2007 14:09
Hi
I don't anderstand your reply.
but telle me if it's possible to do a select after my begin?




Micheal told you how you can see what role have SYSTEM PRIVILEGES and which role have OBJECT PRIVILEGES

SQL> ;
  1  select GRANTEE,OWNER,TABLE_NAME,GRANTOR,PRIVILEGE
  2* from dba_tab_privs
SQL>
GRANTEE              OWNER      TABLE_NAME                     GRANTOR      PRIVILEGE
-------------------- ---------- ------------------------------ ------------ ---------------
GC_READER            GC_ORACLE  PKG_SEL_SCRIPT_NT_READ         GC_ORACLE    EXECUTE
GC_WRITER            GC_ORACLE  PKG_SEL_SCRIPT_NT_READ         GC_ORACLE    EXECUTE
PUBLIC               TS_ORACLE  VW_GET_SITE_DEVICES            TS_ORACLE    SELECT
SQL> select * from role_sys_privs
  2  where role='CONNECT';

ROLE                           PRIVILEGE       ADM
------------------------------ --------------- ---
CONNECT                        CREATE SESSION  NO


[Updated on: Fri, 06 July 2007 15:21]

Report message to a moderator

Re: What Privilege are Recd [message #250007 is a reply to message #250000] Fri, 06 July 2007 15:45 Go to previous message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Thanks

For your time and replies

bye
Previous Topic: sen Mail
Next Topic: Generate triggers on multiple tables (Merged)
Goto Forum:
  


Current Time: Wed Dec 04 19:35:50 CST 2024