Home » RDBMS Server » Security » default role for user
default role for user [message #318901] Thu, 08 May 2008 07:22 Go to next message
nani_ar
Messages: 58
Registered: March 2006
Member
Hi,

I tried to alter the user with defualt role <rolename>, but it is throwing the error, that the role doesn't exist. When i checked the roles in dba_roles, the role is present and password is not required for that. Still I m getting the error as the role is not present. Please advice in this.

sqlplus ram/ram@ram;

SQL>alter user sam default role ram_user;

ORA-01919: role 'RAM_USER' does not exist ;

But when I select it from dba_roles,it shows as the role present.

SQL>Select *from dba_roles where role='RAM_USER';

ROLE PASSWORD REQUIRED
-----------------------------------
RAM_USER NO

I have dba privileges for my user "ram". The same role has been granted to all the other users earlier.

Kindly help me to solve this issue.

Thanks in Advance
Nani

Re: default role for user [message #318948 is a reply to message #318901] Thu, 08 May 2008 08:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Has your user been granted this role?
Query dba_role_privs.

Regards
Michel
Re: default role for user [message #325656 is a reply to message #318901] Sat, 07 June 2008 04:30 Go to previous message
pxgupta2k
Messages: 2
Registered: April 2005
Location: Bangalore
Junior Member
Just try below option.

Alter user username default role ALL;
grant role_name to username;

Thanks
Pankaj
Previous Topic: Creating Oracle Label Security Policy
Next Topic: Error in startup the database.
Goto Forum:
  


Current Time: Fri Dec 09 19:21:22 CST 2016

Total time taken to generate the page: 0.18779 seconds