OraFAQ Forum: Security » To check all privilege available

Home » RDBMS Server » Security » To check all privilege available

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To check all privilege available [message #150644]

Thu, 08 December 2005 18:41

*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.

Report message to a moderator

Re: To check all privilege available [message #150656 is a reply to message #150644]

Thu, 08 December 2005 23:27

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!

Report message to a moderator

Re: To check all privilege available [message #150670 is a reply to message #150644]

Fri, 09 December 2005 00:21

*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.

Report message to a moderator

Re: To check all privilege available [message #150674 is a reply to message #150656]

Fri, 09 December 2005 00:29

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!

Report message to a moderator

Re: To check all privilege available [message #150687 is a reply to message #150644]

Fri, 09 December 2005 01:07

*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.

Report message to a moderator

Re: To check all privilege available [message #150690 is a reply to message #150687]

Fri, 09 December 2005 01:26

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.

Report message to a moderator

Re: To check all privilege available [message #150700 is a reply to message #150644]

Fri, 09 December 2005 02:56

*Jess*
Messages: 48
Registered: December 2005
Location: Penang, Malaysia

Member

ok, got it. Thank you.

Report message to a moderator

Previous Topic:	Proxy authentication
Next Topic:	Database connection restriction

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 21:39:41 CDT 2023