ORA-00905 与 GRANT ALL

SQL> grant all on EMP ,dept  to  public;

grant all on EMP ,dept  to  public

ORA-00905: 缺失关键字

Restriction on Object Privileges

A privilege cannot appear more than once in the list of privileges to be granted.

Specify ALL to grant all the privileges for the object that you have been granted with the GRANT OPTION.

The user who owns the schema containing an object automatically has all privileges

on the object with the GRANT OPTION.

The keyword PRIVILEGES is provided for semantic clarity and is optional.

 

SQL> grant all on EMP   to  public;

Grant succeeded

 

SQL> grant all on dept   to  public;

Grant succeeded