Oracle
1Z0-146 · Question #154
Using SQL*Plus, you created a user with this command: CREATE USER jennifer IDENTIFIED BY jbw122; What should you do to allow the user database access?
The correct answer is B. Grant the user the CREATE SESSION privilege. See the full explanation below for the reasoning.
Question
Using SQL*Plus, you created a user with this command:
CREATE USER jennifer IDENTIFIED BY jbw122; What should you do to allow the user database access?
Options
- AUse the ALTER USER command to assign the user a default tablespace.
- BGrant the user the CREATE SESSION privilege.
- CUse the ALTER USER to assign the user a default profile.
- DNo action is required to give the user database access.
How the community answered
(44 responses)- A2% (1)
- B77% (34)
- C7% (3)
- D14% (6)
Community Discussion
No community discussion yet for this question.