Oracle User Access?

[REM2500]

Hi. Is there a command that I can type into sqlplus as a user to see what kind of access levels I have or what I do and don't have access to?

Thanks!
REM2500

 

[SantaMufasa]

Yes, Rem, you can DESCRIBE and then query (i.e., SELECT...FROM) the following data dictionary views:

user_sys_privs
user_tab_privs
user_role_privs

(and then for the above roles of which you are a member, you can see your "derived" privileges by querying these views:)

role_sys_privs
role_tab_privs
role_role_privs

Let us know if this answers your question(s).

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm. The cost will be your freedoms and your liberty.”

 

[REM2500]

That's exactly what I was looking for.

Thanks!
REM2500