Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

After creating a user named suhail I am trying to grant that user some privileges. But I am getting an error saying missing or invalid privilege . Why is that ?

C:\Windows\system32>SQLPLUS / AS SYSDBA

SQL*Plus: Release 11.2.0.2.0 Production on Tue Mar 5 08:11:35 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
SQL> CREATE USER suhail IDENTIFIED BY InnocentDesire02;
User created.
SQL> GRANT CREATE TABLE,ALTER TABLE,INSERT TABLE,SELECT TABLE,DELETE TABLE,DROP 
VIEW,CREATE ROLE,CREATE SESSION,ALTER SESSION TO suhail;

GRANT CREATE TABLE,ALTER TABLE,INSERT TABLE,SELECT TABLE,DELETE TABLE,DROP VIEW,CREATE   
ROLE,CREATE SESSION,ALTER SESSION TO suhail

               *
ERROR at line 1:
ORA-00990: missing or invalid privilege
share|improve this question

closed as too localized by Justin Cave, Leigh Riffel, Jon Seigel, Mark Storey-Smith, RolandoMySQLDBA Mar 7 at 6:05

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.

1 Answer

up vote 2 down vote accepted

Your list of privileges contains a number that don't exist. There is no ALTER TABLE privilege. Nor is there a SELECT TABLE or DELETE TABLE or DROP VIEW privilege. You can grant a user SELECT access on individual tables that are owned by other users.

share|improve this answer
Then how do I see the data that I am inserting into the table? – Suhail Gupta Mar 5 at 3:12
If there is isn't any select privilege – Suhail Gupta Mar 5 at 3:12
@SuhailGupta - If you own the table, you automatically have access to the data. If you do not own the table, the owner of the table would need to grant you INSERT privileges on the table in order to insert data and SELECT privileges on the table in order to select the data. – Justin Cave Mar 5 at 3:16
okay. Thank you. – Suhail Gupta Mar 5 at 3:21
1  
@SuhailGupta - OK. So you created a user but then didn't log in as that user. You're still logged in as whatever user you used initially to create the suhail user. Based on the output of your query, I'm assuming that you logged in as SYS initially and are still logged in as SYS. – Justin Cave Mar 5 at 3:50
show 3 more comments

Not the answer you're looking for? Browse other questions tagged or ask your own question.