User Roles [message #520161] |
Fri, 19 August 2011 00:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Is there any default way to assign user roles to uses ?
Suppose I want assign to user different roles to different users on views, tables etc.
I nut shell I wan to implement Access control list & Access request objects (ACL/ARO).
Thanks in Advance
Waseem
[Updated on: Fri, 19 August 2011 00:34] Report message to a moderator
|
|
|
|
Re: User Roles [message #520169 is a reply to message #520161] |
Fri, 19 August 2011 01:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Please can you explain what these are in this context:
Quote:Access control list & Access request objects (ACL/ARO).
|
|
|
|
Re: User Roles [message #520172 is a reply to message #520169] |
Fri, 19 August 2011 01:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
ACL/ARO to set users' roles and access levels, like administrators can access curtain tables & views, clerks can access other and usertype2 can others.
Thanks
Waseem
|
|
|
|
|
Re: User Roles [message #520183 is a reply to message #520180] |
Fri, 19 August 2011 02:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68663 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Query DBA_ROLE_PRIVS, ROLE_ROLE_PRIVS, ROLE_SYS_PRIVS, ROLE_TAB_PRIVS...
All catalog views are described in Database Reference
You can find the views related to a question using DICT view, for instance:
select table_name, comments from dict where lower(comments) like '%role%';
select table_name, comments from dict where lower(comments) like '%privilege%';
Regards
Michel
[Updated on: Fri, 19 August 2011 02:55] Report message to a moderator
|
|
|