Home » RDBMS Server » Networking and Gateways » Granting of role giving an error
Granting of role giving an error [message #222544] Mon, 05 March 2007 06:46 Go to next message
Messages: 95
Registered: February 2007

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
Re: Granting of role giving an error [message #222548 is a reply to message #222544] Mon, 05 March 2007 06:51 Go to previous message
Mahesh Rajendran
Messages: 10673
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.
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.
Previous Topic: issue with oracle connection string
Next Topic: listener running, but unable to listen client
Goto Forum:

Current Time: Thu Jul 27 18:16:54 CDT 2017

Total time taken to generate the page: 0.13276 seconds