OraFAQ Forum: SQL & PL/SQL » ORA-01917: user or role 'XXXX' does not exist (merged 3)

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01917: user or role 'XXXX' does not exist (merged 3) (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod)

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

ORA-01917: user or role 'XXXX' does not exist (merged 3) [message #509146]

Thu, 26 May 2011 05:15

shamsh_pervaiz
Messages: 22
Registered: September 2005
Location: bangalore

Junior Member

Hi There,

I just created a role as
CREATE ROLE XXXX;
Then tried to grant a privilege, but getting error as below:

grant alter on schema.table_name to XXXX;
ORA-01917: user or role 'MACH_ALTER_ROAMXDB' does not exist

Your help will be really appreciated.

Thanks in advance,
Shamsh

Report message to a moderator

Re: ORA-01917: user or role 'XXXX' does not exist (merged 2) [message #509150 is a reply to message #509146]

Thu, 26 May 2011 05:17

cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester

Senior Member

You did something wrong. Copy and paste your whole session so we can see exactly what you did.

Report message to a moderator

Re: ORA-01917: user or role 'XXXX' does not exist (merged 2) [message #509151 is a reply to message #509150]

Thu, 26 May 2011 05:24

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

Senior Member

ind> create role test identified by role_password;

Role created.

ind> grant alter on appowner.emp_sriram to role;
grant alter on appowner.emp_sriram to role
                                      *
ERROR at line 1:
ORA-01917: user or role 'ROLE' does not exist


ind> grant alter on appowner.emp_sriram to test ;

Grant succeeded.

ind>

Report message to a moderator