How to change DEFAULT_ROLE of a user [message #515773] |
Wed, 13 July 2011 04:09 |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
|
|
Hi ,
I want to change the DEFAULT_ROLE column to NO for following user 'P10_DEMO'.
SQL> show user
USER is "BALA"
SQL>
SQL>
SQL> select name from v$database;
NAME
---------
JAMD2
SQL> select * from dba_role_privs where granted_role='DEVELOPER' and grantee='P10_DEMO';
GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE
------------------------------ ---------------------------------- ------------
P10_DEMO DEVELOPER NO YES
Can you please guide me how to do this ?
Thanks
[Updated on: Wed, 13 July 2011 04:19] by Moderator Report message to a moderator
|
|
|
|
|
Re: How to change DEFAULT_ROLE of a user [message #515794 is a reply to message #515790] |
Wed, 13 July 2011 04:43 |
cookiemonster
Messages: 13958 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
@balaji14 - do you know why we know so much about oracle? Because we know how to look things up.
We've told you to do this numerous times, not becuase we're lazy, but because you will never become competent at your job until you learn to do so.
so let's try it right now shall we?
Click on this link
Click on your oracle version.
Type alter user into the search box.
In the results page click on the link with the word SYNTAX next to it.
Read that page and work out the answer.
|
|
|
|
|
|
|
Re: How to change DEFAULT_ROLE of a user [message #515908 is a reply to message #515819] |
Thu, 14 July 2011 02:58 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
In addition, in the same way you have to put the code between CODE tags, you have to put the text you quote between QUOTE tags and not after them.
"A child could follow those instructions."
Regards
Michel
|
|
|