Home » RDBMS Server » Security » To check all privilege available
To check all privilege available [message #150644] Thu, 08 December 2005 18:41 Go to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Hi, I'm new in Oracle, working as a DBA. I would like to know how to check all privilege available in oracle regardless of any role.

Thanks in advance.
Re: To check all privilege available [message #150656 is a reply to message #150644] Thu, 08 December 2005 23:27 Go to previous messageGo to next message
ramsat
Messages: 49
Registered: November 2005
Member
Hai,
check out the below tables
dba_role_privs
dba_roles


I hope i got u what u want.

Bye!
Re: To check all privilege available [message #150670 is a reply to message #150644] Fri, 09 December 2005 00:21 Go to previous messageGo to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Thanks for your reply.

I would like to check all the privilege avalaible in oracle. dba_role_privs and dba_sys_privs will only shows a specific role with a specific privilege granted.

Is there any command to do so? Thank you.

Re: To check all privilege available [message #150674 is a reply to message #150656] Fri, 09 December 2005 00:29 Go to previous messageGo to next message
ramsat
Messages: 49
Registered: November 2005
Member
Hai,

check out at least this works

user$
defrole$
dba_roles
dba_role_privs
role_role_privs
role_sys_privs
role_tab_privs
session_roles
user_application_roles
user_role_privs
v$pwfile_users

bye!
Re: To check all privilege available [message #150687 is a reply to message #150644] Fri, 09 December 2005 01:07 Go to previous messageGo to next message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

Thanks a lot ramsat, I'd get what I wan.

Another question hope you don't mind. For user$, what is the meaning for this $ behind? v$pwfile_user as my understanding is a view right?

I'm very fresh in Oracle, need to put a lot of effort in learning, thanks a lot.
Re: To check all privilege available [message #150690 is a reply to message #150687] Fri, 09 December 2005 01:26 Go to previous messageGo to next message
ramsat
Messages: 49
Registered: November 2005
Member
Hai,

There is not much difference between the table definition what u create and the table_name$.


To oracle it internally has many tables and for many purpose. It may use a hash function to filter the table name to find out exactly the location of the table and its stuff.
Re: To check all privilege available [message #150700 is a reply to message #150644] Fri, 09 December 2005 02:56 Go to previous message
*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia
Member

ok, got it. Thank you.
Previous Topic: Proxy authentication
Next Topic: Database connection restriction
Goto Forum:
  


Current Time: Thu Mar 28 17:05:41 CDT 2024