|
|
|
|
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418691 is a reply to message #418684] |
Tue, 18 August 2009 03:16 |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Out of curiosity, what's wrong with just granting DBA to the user?
If you look here you'll find a list of things you can grant. Just guessing at the syntax isn't likely to work
Quote: | grant usage any table to Superuser;
|
No idea what this is meant to be.
Quote: | grant temporary any table to Superuser;
|
No Idea
Quote: | grant create Trigger any table to Superuser;
|
GRANT CREATE ANY TRIGGER
Quote: | grant Referenzen any table to Superuser;
|
You can Grant REFERENCE on a specific table to someone. I don't think there's a REFERENCE ANY....
Quote: | grant TRUNCATE any table to Superuser;
|
TRUNCATE ANY come with the DROP ANY privilege
|
|
|
|
|
|