| What Privilege are Recd [message #250000] |
Fri, 06 July 2007 14:22  |
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 #250006 is a reply to message #250005] |
Fri, 06 July 2007 15:16  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
