Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't i GRANT multiple privileges (comma separated) in one go?

MaxAug 17 2011 — edited Aug 17 2011
DB version: 11.1
Os Platform: AIX

Connected to sqlplus in AIX.
SQL> grant LMRL , 
 CREATE LIBRARY ,
 EXECUTE ON SYS.UTL_FILE , 
 UNLIMITED TABLESPACE,
 EXECUTE ON SYS.DBMS_PIPE ,
 EXECUTE ON SYS.UTL_FILE,
 select on DBA_OBJECTS,
 select on DBA_ERRORS to  
 myuser;  2    3    4    5    6    7    8    9  
grant LMRL ,
      *
ERROR at line 1:
ORA-00990: missing or invalid privilege

-- Removing LMRL role

SQL> grant 
 CREATE LIBRARY ,
 EXECUTE ON SYS.UTL_FILE , 
 UNLIMITED TABLESPACE,
 EXECUTE ON SYS.DBMS_PIPE ,
 EXECUTE ON SYS.UTL_FILE,
 select on DBA_OBJECTS,
 select on DBA_ERRORS to  
 myuser;  
  2    3    4    5    6    7    8    9   CREATE LIBRARY ,
 *
ERROR at line 2:
ORA-00990: missing or invalid privilege

-- Removed the new lines and put everything on one line
grant CREATE LIBRARY ,EXECUTE ON SYS.UTL_FILE , UNLIMITED TABLESPACE,EXECUTE ON SYS.DBMS_PIPE ,EXECUTE ON SYS.UTL_FILE,select on DBA_OBJECTS,select on DBA_ERRORS to myuser;  
ERROR at line 1:
ORA-00990: missing or invalid privilege
But, when i GRANT these privileges/Roles individually, it works
SQL> grant LMRL to  myuser;

Grant succeeded.

SQL> grant execute on SYS.UTL_FILE to  myuser;

Grant succeeded.

SQL> grant create library to myuser;

Grant succeeded.

SQL> grant UNLIMITED TABLESPACE to myuser;

Grant succeeded.

SQL> grant select on DBA_OBJECTS to myuser;

Grant succeeded.
I don't know if this happens only when i connect locally from AIX. For this DB , i can' connect remotely and test.
This post has been answered by Hemant K Chitale on Aug 17 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2011
Added on Aug 17 2011
4 comments
7,959 views