| What's a default role in dba_role_privs? [message #334778] |
Fri, 18 July 2008 00:16  |
Smith_X
Messages: 56
Registered: January 2007
|
Member |
|
|
SELECT *
FROM dba_role_privs;
NAME ADM DEF
------ ------ --------
R1 YES YES
R2 NO YES
(sample result and code)
I notice that the return is only YES.
I try to gooel but I cannot find the answer for this vaule.
What does it mean if it is YES and NO, please?
|
|
|
|
|
|
|
|
| Re: What's a default role in dba_role_privs? [message #335093 is a reply to message #334778] |
Mon, 21 July 2008 00:03  |
Smith_X
Messages: 56
Registered: January 2007
|
Member |
|
|
Thank you very much for your reply Michel Cadot
Excuse me, I still not get it throughly. Would you mind if I want you to explain a little bit more, please?
Example. If I have Role_A assigns to User_A and User_B and then I make a change in Role_A to add some role in Role_A with DEFAULT_ROLE = NO. So, what does this mean??
on the other hand, if I add some role in Role_A with DEFAULT_ROLE = YES then, what's happen please?
Thank you in advance.
Regards,
Smith_X
|
|
|
|
| Re: What's a default role in dba_role_privs? [message #335111 is a reply to message #335093] |
Mon, 21 July 2008 01:06 |
 |
Michel Cadot
Messages: 68748
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
| Quote: | Example. If I have Role_A assigns to User_A and User_B and then I make a change in Role_A to add some role in Role_A with DEFAULT_ROLE = NO. So, what does this mean??
on the other hand, if I add some role in Role_A with DEFAULT_ROLE = YES then, what's happen please?
|
You don't add roles to roles with default_role yes or no. It is meaningless for a role to have a role as default or not, so you can't choose it.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
