問題文
A reporting user has to read a table that lives in another schema and the team does not want the schema name written into every query. Two kinds of synonym are available. Which statement describes how the two differ in reach?
選択肢
- A private synonym lives in one schema and belongs to its owner while a public synonym is visible to every user of the database.
- A private synonym points at one table in a schema while a public synonym points at every table that shares that name.
- A private synonym carries the privileges of its owner while a public synonym carries the privileges of the user who reads it.
- A private synonym lives in one schema and hides the table from its owner while a public synonym exposes it to that owner.