OraFAQ Forum: Networking and Gateways » Granting of role giving an error

Home » RDBMS Server » Networking and Gateways » Granting of role giving an error

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

Granting of role giving an error [message #222544]

Mon, 05 March 2007 06:46

donind
Messages: 95
Registered: February 2007

Member

Hi,

I am having dba privilege while creating a role.

Create role role1;

grant insert, update, delete yo role1;

But its errored out.

Role insert doesnot exist.

Thanks in advance

Report message to a moderator

Re: Granting of role giving an error [message #222548 is a reply to message #222544]

Mon, 05 March 2007 06:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

That is because you cannot assign more one priv in a single statment. But you can grant more than one role in one statement.
And, there no such roles insert/delete as you used.

Code: [Select all] [Show/ hide]

scott@9i > create role role1;

Role created.

scott@9i > grant insert,delete to role1;
grant insert,delete to role1
      *
ERROR at line 1:
ORA-01919: role 'INSERT' does not exist


scott@9i > grant select on emp to role1;

Grant succeeded.

scott@9i > grant connect,resource to role1;

Grant succeeded.

Report message to a moderator

Previous Topic:	issue with oracle connection string
Next Topic:	listener running, but unable to listen client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 18:43:02 CDT 2025