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
SQL> grant execute on sys.dbms_lock
2 to andrew
3 /
Grant succeeded.
SQL>
No comments:
Post a Comment