Oracle
1Z0-063 · Question #206
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN. and then execute the command: Which statement is true?
The correct answer is C. The command fails because the CONTAINER clause is not used. For commonly granted privileges the grantor must be connected to the root and must specify CONTAINER=ALL in the GRANT statement.
Managing Database Security
Question
In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN. and then execute the command: Which statement is true?
Options
- AThe command executes successfully, enabling the C##A_ADMIN user to create a tablespace only
- BThe command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the
- CThe command fails because the CONTAINER clause is not used.
- DThe command fails because system privileges cannot be granted to a common user.
How the community answered
(49 responses)- A4% (2)
- B2% (1)
- C84% (41)
- D10% (5)
Explanation
For commonly granted privileges the grantor must be connected to the root and must specify CONTAINER=ALL in the GRANT statement.
Topics
#common user#CONTAINER clause#CDB privileges#multitenant security
Community Discussion
No community discussion yet for this question.