OraFAQ Forum: SQL & PL/SQL » Existing role claimed to be not existing

Home » SQL & PL/SQL » SQL & PL/SQL » Existing role claimed to be not existing (Oracle 11.1, RedHat Linux 5.6)

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

Existing role claimed to be not existing [message #536206]

Mon, 19 December 2011 14:40

brieck
Messages: 5
Registered: December 2011

Junior Member

Hello,

I'm am getting an error that says that a role doesn't exist when I can cleary see it in DBA_ROLES. I can successfully grant other roles in this session. I am using Oracle 11.1 on RAC. Does anybody know why this is happening?

GRANT "CONNECT" TO BAKERD
Error at line 1
ORA-01919: role 'CONNECT' does not exist

select * from dba_roles where role = 'CONNECT'

ROLE PASSWORD_REQUIRED
------------------------------ -----------------
CONNECT NO
1 row selected.

[Updated on: Mon, 19 December 2011 14:43]

Report message to a moderator

Re: Existing role claimed to be [message #536208 is a reply to message #536206]

Mon, 19 December 2011 14:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>GRANT "CONNECT" TO BAKERD
not as above but as below

GRANT CONNECT TO BAKERD;

Report message to a moderator

Re: Existing role claimed to be [message #536210 is a reply to message #536208]

Mon, 19 December 2011 14:50

brieck
Messages: 5
Registered: December 2011

Junior Member

Unfortunately I get the same error.

GRANT CONNECT TO BAKERD;

GRANT CONNECT TO BAKERD;
Error at line 1
ORA-01919: role 'CONNECT' does not exist

Report message to a moderator

Re: Existing role claimed to be [message #536212 is a reply to message #536210]

Mon, 19 December 2011 15:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> connect / as sysdba
Connected.
SQL> select role from dba_roles where role like 'C%';

ROLE
------------------------------
CONNECT
CTXAPP
CWM_USER
CSW_USR_ROLE

SQL> grant connect to user3;

Grant succeeded.

SQL> !oerr ora 1919
01919, 00000, "role '%s' does not exist"
// *Cause:  Role by that name does not exist.
// *Action: Verify you are using the correct role name.
SQL> connect user1/user1
Connected.
SQL> ed
Wrote file afiedt.buf

  1* grant connect to user3
SQL> /
grant connect to user3
*
ERROR at line 1:
ORA-01919: role 'CONNECT' does not exist


SQL>

Report message to a moderator

Re: Existing role claimed to be not existing [message #536213 is a reply to message #536206]

Mon, 19 December 2011 15:06

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

What schema are you in when trying to grant this role?

Cut and paste your entire session.

Report message to a moderator

Re: Existing role claimed to be [message #536214 is a reply to message #536210]

Mon, 19 December 2011 15:06

Solomon Yakobson
Messages: 3305
Registered: January 2010
Location: Connecticut, USA

Senior Member

Don't confuse being able to select from dba_roles with being able to grant roles:

SQL> grant select on dba_roles to u1;

Grant succeeded.

SQL> connect u1@orcl
Enter password: **
Connected.
SQL> select * from dba_roles where role = 'CONNECT'
  2  /

ROLE                           PASSWORD AUTHENTICAT
------------------------------ -------- -----------
CONNECT                        NO       NONE

SQL> grant connect to u2;
grant connect to u2
*
ERROR at line 1:
ORA-01919: role 'CONNECT' does not exist


SQL>

And now:

SQL> grant grant any role to u1
  2  /

Grant succeeded.

SQL> connect u1@orcl
Enter password: **
Connected.
SQL> grant connect to u2;

Grant succeeded.

SQL>

SY.

[Updated on: Mon, 19 December 2011 15:12]

Report message to a moderator

Previous Topic:	assign the end date
Next Topic:	Inserting 300 millions records into an oracle table using database links(3 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 04 13:27:41 CDT 2026