93. The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS
table to the user HR.
Which statement would create a synonym ORD so that HR can execute the following query successfully?
SELECT * FROM ord?
A. CREATE SYNONYM ord FOR orders? This command is issued by OE.
B. CREATE PUBLIC SYNONYM ord FOR orders? This command is issued by OE.
C. CREATE SYNONYM ord FOR oe.orders? This command is issued by the database administrator.
D. CREATE PUBLIC SYNONYM ord FOR oe.orders? This command is issued by the database administrator.
Answer: D
答案B为什么不对,因为OE不一定有create public synonym权限吗?
请各位指教。
To create a private synonym in your own schema, you must have the CREATE SYNONYM privilege. To create a private synonym in another user's schema, you must have the CREATE ANY SYNONYM privilege