 User Roles [message #520161] |
Fri, 19 August 2011 00:04  |
|
|
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  |
John Watson
Messages: 8966
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 |
|
|
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 |
 |
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
