The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?

The correct answer is A. No privileges. There are no privileges for the user Scott at this point. They are not added themselves to the user immediately after creation. The DBA needs to grant all privileges explicitly. Incorrect Answers B: There are no privileges for the user Scott at this point. SELECT privilege…

Controlling User Access

Question

The DBA issues this SQL command:

CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?

Options

ANo privileges.
BOnly the SELECT privilege.
COnly the CONNECT privilege.
DAll the privileges of a default user.

How the community answered

(38 responses)

A
76% (29)
B
5% (2)
C
3% (1)
D
16% (6)

Explanation

There are no privileges for the user Scott at this point. They are not added themselves to the user immediately after creation. The DBA needs to grant all privileges explicitly. Incorrect Answers B: There are no privileges for the user Scott at this point. SELECT privilege needs to be added to C: There are no privileges for the user Scott at this point. CONNECT privilege needs to be added to the user Scott. D: There is no default user in Oracle.

Topics

#CREATE USER#default privileges#no privileges#user creation

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice