本文探讨了一段SQLGRANT语句的问题，该语句由SCOTT用户发出，旨在授予所有权限给PUBLIC角色，涉及ORDERS和ORDER_ITEMS两个表。文章指出，为了正确执行，该语句需要被拆分为针对每个表的单独GRANT语句。
3、choose the best answer:
The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?
A) ALL should be replaced with a list of specific privileges.
B) WITH GRANT OPTION should be added to the statement.
C) PUBLIC should be replaced with specific usernames.
D) Separate GRANT statements are required for the ORDERS and ORDER_ITEMS tables.
Answer:D
扫一扫
2138
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
