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. when a user is created, by default no privilege is granted Incorrect answer: B SELECT is not grant C CONNECT is not grant D default profile is grant by default not 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

(27 responses)

A
74% (20)
B
7% (2)
C
4% (1)
D
15% (4)

Explanation

when a user is created, by default no privilege is granted Incorrect answer: B SELECT is not grant C CONNECT is not grant D default profile is grant by default not privilege.

Topics

#CREATE USER#user privileges#Oracle security#DCL

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice