The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues
the following GRANT command:
GRANT ALL ON orders, order_items TO PUBLIC;
What correction needs to be done to the above statement?
A. PUBLIC should be replaced with specific usernames.
B. ALL should be replaced with a list of specific privileges.
C. WITH GRANT OPTION should be added to the statement.
D. Separate GRANT statements are required for ORDERS and ORDER_ITEMS tables.
Answer: D
grant all to public;//这条比较重要，授予所有权限(all)给所有用户(public)
Eg:
SQL> GRANT ALL ON test,wdz1 TO PUBLIC
第1 行出现错误:
ORA-00905: 缺失关键字
SQL> GRANT ALL ON test TO PUBLIC;
授权成功。
SQL> GRANT ALL ON wdz1 TO PUBLIC;
授权成功。
