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.