hi,
i am preparing for oracle certifications, in some sample question and answers i see the below question.
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;
Options:
1. CREATE SYNONYM ord FOR orders; This command is issued by OE.
2. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by
OE.
3. CREATE SYNONYM ord FOR oe.orders; This command is issued by the
database administrator.
4. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is
issued by the database administrator.
Ans: 4
i agree that opt.4 is correct but, i can see option 2 is also correct because we can create a synonym on the schema where the table is present. can you please tell me i am correct.
even i have tested this scenario so option 2 is working for me.
thanks,