OraFAQ Forum: Security » Assigning roles

Home » RDBMS Server » Security » Assigning roles (oracle 10.2.0.4.0,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Assigning roles [message #436255]

Tue, 22 December 2009 07:37

Hitman11
Messages: 94
Registered: October 2009
Location: norway

Member

Hi all,

I have a doubt in assigning default role to user while creating database account.

Can somebody tell me, Is there any difference in below 2 commands or
they have same meaning?

GRANT NEWROLE TO DREAM;

ALTER USER DREAM DEFAULT ROLE NEWROLE;

Thanks

Report message to a moderator

Re: Assigning roles [message #436256 is a reply to message #436255]

Tue, 22 December 2009 07:40

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

When a user logs into Oracle, all default roles are enabled, but non-default roles must be enabled with the SET ROLE statement.

Report message to a moderator

Re: Assigning roles [message #436263 is a reply to message #436255]

Tue, 22 December 2009 08:38

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

GRANT => grant a role
ALTER USER => define what are the default roles among those that have been granted

Regards
Michel

Report message to a moderator

Re: Assigning roles [message #436264 is a reply to message #436263]

Tue, 22 December 2009 09:09

Hitman11
Messages: 94
Registered: October 2009
Location: norway

Member

Thanks

Report message to a moderator

Re: Assigning roles [message #436299 is a reply to message #436264]

Tue, 22 December 2009 20:59

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

This will help you

Quote:

Is there any difference in below 2 commands

One is DCL another one is DDL Wink

Wink

Sriram

Smile

Report message to a moderator

Previous Topic:	Password Policy
Next Topic:	Privileges on create procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 16 16:27:12 CST 2026