Home » RDBMS Server » Security » error: ora01931 grant references to a role
error: ora01931 grant references to a role [message #10936] Wed, 25 February 2004 00:43 Go to next message
rushing
Messages: 135
Registered: January 2004
Location: Beijing,China
Senior Member
When grant the references to a role, the error ora01931 occured.

How to deal with it?

Thanks!
Re: error: ora01931 grant references to a role [message #10937 is a reply to message #10936] Wed, 25 February 2004 01:30 Go to previous message
shad
Messages: 50
Registered: October 2000
Member
But as the error says, it is not possible to grant UNLIMITED TABLESPACE, REFERENCES, INDEX, SYSDBA or SYSOPER privileges to a role. That needs to be granted to a specific user.

hope this helps.
Previous Topic: Privs to a user.
Next Topic: issue with fine grain policies
Goto Forum:
  


Current Time: Sun Sep 26 02:38:31 CDT 2021