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!

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 07:40:23 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.