104. 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;
授权成功。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718911/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
