nerdexam
Oracle

1Z0-061 · Question #258

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

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
    74% (28)
  • B
    3% (1)
  • C
    16% (6)
  • D
    8% (3)

Explanation

when a user is created, by default no privilege is granted

Topics

#CREATE USER#privileges#GRANT#user creation

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice