Oracle
1Z0-082 · Question #89
In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)
The correct answer is A. Revoke the CREATE SESSION privilege from other users D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users E. Execute DDL statements in the HR schema. https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224
Administer User Security
Question
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform? (Choose three.)
Options
- ARevoke the CREATE SESSION privilege from other users
- BRevoke the CREATE SESSION privilege from user HR
- CLog in to the database instance
- DGrant the CREATE SESSION privilege with ADMIN OPTION to other users
- EExecute DDL statements in the HR schema
- FExecute DML statements in the HR schema
How the community answered
(23 responses)- A78% (18)
- B4% (1)
- C13% (3)
- F4% (1)
Explanation
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224
Topics
#ADMIN OPTION#system privileges#CREATE SESSION#privilege delegation
Community Discussion
No community discussion yet for this question.