Home » RDBMS Server » Security » Tables - roles
Tables - roles [message #29768] Sun, 21 March 2004 22:35 Go to next message
Nauj
Messages: 33
Registered: February 2004
Member
Hi,

I want to know if there is any system view that show the tables associeted with one role.
For example, when I execute this:
'grant select on dwb_tp_dm_area  to WTDWB1_ROL_READ'
is registered in any system view???
How can I search the tables associated in one role??

I'm using Oracle9i

Any advice will be greatly aprecietted.Thanks in advance.

Report message to a moderator

Re: Tables - roles [message #29778 is a reply to message #29768] Mon, 22 March 2004 05:55 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
you mean table privileges granted to role ?

role_tab_privs
dba_tab_privs

Report message to a moderator

Previous Topic: How to audit dml operations to tables which include old value ,new value without using dml triggers
Next Topic: Create role
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 18 03:42:39 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.