Wednesday, June 20, 2012

ORA-00990


This was tested on Oracle 11. You can grant roles and system privileges in the same statement. But if you want to include object privileges, you need to use a new GRANT statement:

SQL> grant dba, alter system,
  2  execute on sys.dbms_lock
  3  to andrew
  4  /
grant dba, alter system,
      *
ERROR at line 1:
ORA-00990: missing or invalid privilege

SQL> grant dba, alter system
  2  to andrew
  3  /

Grant succeeded.

SQL> grant execute on sys.dbms_lock
  2  to andrew
  3  /

Grant succeeded.

SQL>

No comments: