Home » RDBMS Server » Security » How to change DEFAULT_ROLE of a user
How to change DEFAULT_ROLE of a user [message #515773] Wed, 13 July 2011 04:09 Go to next message
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 #515786 is a reply to message #515773] Wed, 13 July 2011 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You must put your code between [code] and [/code] not after them.

ALTER USER DEFAULT ROLE <role list>;
or
ALTER USER DEFAULT ROLE NONE;

Regards
Michel

Re: How to change DEFAULT_ROLE of a user [message #515790 is a reply to message #515786] Wed, 13 July 2011 04:27 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Ok. I will follow it from next time.

Quote:

ALTER USER DEFAULT ROLE NONE


where to give the username in this command ? I want to change this default role to a particular user 'P10_DEMO';

Thanks
Re: How to change DEFAULT_ROLE of a user [message #515794 is a reply to message #515790] Wed, 13 July 2011 04:43 Go to previous messageGo to next message
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 #515802 is a reply to message #515794] Wed, 13 July 2011 05:32 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



I dont find the relevant topic in the document.....

Anyhow the command should be like this i guess.


ALTER USER P10_DEMO DEFAULT ROLE NONE;

Thanks

Re: How to change DEFAULT_ROLE of a user [message #515803 is a reply to message #515802] Wed, 13 July 2011 05:37 Go to previous messageGo to next message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
balaji14 wrote on Wed, 13 July 2011 11:32


I dont find the relevant topic in the document.....



What?!?!?!?!

I gave you exact instructions to take you the correct topic!

You are not even trying are you?
Re: How to change DEFAULT_ROLE of a user [message #515814 is a reply to message #515803] Wed, 13 July 2011 07:42 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member


Quote:
You are not even trying are you?


I tried but did not get the output.
Re: How to change DEFAULT_ROLE of a user [message #515819 is a reply to message #515814] Wed, 13 July 2011 08:07 Go to previous messageGo to next message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
You followed the instructions I gave and didn't manage to find this page?

A child could follow those instructions.
Re: How to change DEFAULT_ROLE of a user [message #515908 is a reply to message #515819] Thu, 14 July 2011 02:58 Go to previous message
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
Previous Topic: Grant privs to public user
Next Topic: IDLE TIME - not in effect
Goto Forum:
  


Current Time: Sat Nov 23 04:44:38 CST 2024