Home » SQL & PL/SQL » SQL & PL/SQL » ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) (Oracle 11g)
icon3.gif  ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418674] Tue, 18 August 2009 01:53 Go to next message
Strahlungsleck
Messages: 5
Registered: August 2009
Location: Karlsruhe
Junior Member

Hey, first off all i hope u can understand me, because my
english isn´t well...
And i´m a totaly newbie with Oracle so I hope you can help me please.

I´m trying to create a User in Oracle and give him some grants.

create user Superuser  
	identified by superuser	
	default tablespace EXAMPLE
	temporary tablespace TEMP
	profile default 
    account unlock;
      
   
	  
	 grant connect to system;
	 grant create session to Superuser;
         grant update any table to Superuser;
	 grant delete any table to Superuser;
 	 grant select any table to Superuser;
	 grant insert any table to Superuser;
	 grant create any table to Superuser;
	 grant unlimited tablespace to Superuser;  

/* So grants over here are working, but the the statesmant under
hier want work and i get everytime the same failure...
(ORA-0090 : missing or invalid privilege)
*/
	 

         grant usage any table to Superuser;
	 grant temporary any table to Superuser;
	 grant create Trigger any table to Superuser;
	 grant Referenzen any table to Superuser;
	 grant TRUNCATE any table to Superuser;

     
	


So try to create the user with the following accounts:
System, Sysman or Sys
and i didn´t know why it doesn´t work...
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418677 is a reply to message #418674] Tue, 18 August 2009 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
grant Referenzen any table to Superuser

I doubt this is a valid privilege.
Same thing for the other statements.
Refer to SQL Reference for the valid privilege list.

Next time, please use SQL*Plus and copy and paste your session.

Regards
Michel
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418684 is a reply to message #418677] Tue, 18 August 2009 02:27 Go to previous messageGo to next message
Strahlungsleck
Messages: 5
Registered: August 2009
Location: Karlsruhe
Junior Member

Michel Cadot wrote on Tue, 18 August 2009 09:01
Quote:
grant Referenzen any table to Superuser

I doubt this is a valid privilege.
Same thing for the other statements.
Refer to LINK for the valid privilege list.

Next time, please use SQL*Plus and copy and paste your session.

Regards
Michel






Hi Michel
the problem is that i can´t connect with SQL*Plus
since i create a second DB and delete them =/
So i got every time the following failure:
Quote:
SQL*Plus: Release 11.1.0.6.0 - Production on Di Aug 18 09:14:16 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Benutzernamen eingeben: system
Kennwort eingeben:
ERROR:
ORA-12560: TNS: Fehler bei Protokolladapter


But bevor i create the second database I used most of the time
eclipse with database developmentplugin and the SQL-Developer
from Oracle.

So this is the log/Script Output from SQL-Developer:
And i only correct Referenzen to reference
create user succeeded.
grant connect succeeded.
grant create succeeded.
grant update succeeded.
grant delete succeeded.
grant select succeeded.
grant insert succeeded.
grant create succeeded.
grant unlimited succeeded.

Error starting at line 21 in command:
     grant  usage any table to Superuser
Error report:
SQL Error: ORA-00990: Fehlende oder ungültige Berechtigung
00990. 00000 -  "missing or invalid privilege"
*Cause:    
*Action:

Error starting at line 22 in command:
	 grant  temporary any table to Superuser
Error report:
SQL Error: ORA-00990: Fehlende oder ungültige Berechtigung
00990. 00000 -  "missing or invalid privilege"
*Cause:    
*Action:

Error starting at line 23 in command:
	 grant  create Trigger any table to Superuser
Error report:
SQL Error: ORA-00990: Fehlende oder ungültige Berechtigung
00990. 00000 -  "missing or invalid privilege"
*Cause:    
*Action:

Error starting at line 24 in command:
	 grant Reference any table to Superuser
Error report:
SQL Error: ORA-00990: Fehlende oder ungültige Berechtigung
00990. 00000 -  "missing or invalid privilege"
*Cause:    
*Action:

Error starting at line 25 in command:
	 grant TRUNCATE any table to Superuser
Error report:
SQL Error: ORA-00990: Fehlende oder ungültige Berechtigung
00990. 00000 -  "missing or invalid privilege"
*Cause:    
*Action:


So you see i´m so bad in this... but i have to learn this...
And thanks for the Link i look there and i hope i understand this, that i can correct the failure by myself.

Thank Michel for your help !
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418687 is a reply to message #418684] Tue, 18 August 2009 02:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For your error 12560, if the database is local, you have to set ORACLE_SID environment variable, if the database is remote, you have to use service name from tnsname.ora.
See Database Net Services Administrator's Guide

Regards
Michel
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 Go to previous messageGo to next message
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
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418709 is a reply to message #418691] Tue, 18 August 2009 04:41 Go to previous messageGo to next message
Strahlungsleck
Messages: 5
Registered: August 2009
Location: Karlsruhe
Junior Member

JRowbottom wrote on Tue, 18 August 2009 10:16
Out of curiosity, what's wrong with just granting DBA to the user?



Thats the best way, because the Superuser should to do all.

Finally it was so easy with the permission of the "Superuser"
and i make it so difficult for me =/

and now i try it with two other user which i have to create
and give them some rights

So thanks to all for your help

i´m glad that i have find this forum Wink
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418745 is a reply to message #418674] Tue, 18 August 2009 08:10 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Strahlungsleck wrote on Tue, 18 August 2009 02:53

	 grant connect to system;




I think that is dangerous. SYSTEM would already have connect privs. This can only make things worse by making changes to SYSTEM, even if it is not changing privs it already has.
Re: ORA-0090 : missing or invalid privilege (create user und give/grant him privilege) [message #418754 is a reply to message #418745] Tue, 18 August 2009 08:51 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, don't use SYSTEM, SYSTEM is for Oracle Corp., create your own user and grant them the required privileges or roles.

Regards
Michel
Previous Topic: uneven rows saved
Next Topic: Spool + user defined cells
Goto Forum:
  


Current Time: Sat Dec 03 20:35:01 CST 2016

Total time taken to generate the page: 0.12691 seconds