OCP-047 CREATE SYNONYM ord FOR orders

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

解析：

建立同義詞：

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. To create a public synonym, you must have the 

CREATE PUBLIC SYNONYM

 system privilege.

在hr有通路 OE.orders 表的權限條件下:

如果OE使用者有建立私有和公有同義詞的權限，則B，D都能正常通路；

 A public synonym is owned by the special user group named 

PUBLIC

 and is accessible to every user in a database.

 A private synonym is contained in the schema of a specific user and available only to the user and the user's grantees. 

私有同義詞對其他使用者通路需要授權；

如果執行的語句是select * from oe.ord 則A,B正确