OraFAQ Forum: Security » default role for user

Home » RDBMS Server » Security » default role for user

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

default role for user [message #318901]

Thu, 08 May 2008 07:22

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

Report message to a moderator