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
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
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: 10672
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: Wed Dec 07 12:42:20 CST 2016

Total time taken to generate the page: 0.05111 seconds