nerdexam
Oracle

1Z0-061 · Question #204

What is true about the WITH GRANT OPTION clause?

The correct answer is E. It allows the grantee to grant object privileges to other users and roles. The GRANT command with the WITH GRANT OPTION clause allows the grantee to grant object privileges to other users and roles.

Controlling User Access

Question

What is true about the WITH GRANT OPTION clause?

Options

  • AIt allows a grantee DBA privileges.
  • BIt is required syntax for object privileges.
  • CIt allows privileges on specified columns of tables.
  • DIt is used to grant an object privilege on a foreign key column.
  • EIt allows the grantee to grant object privileges to other users and roles.

How the community answered

(34 responses)
  • A
    15% (5)
  • B
    6% (2)
  • C
    3% (1)
  • D
    3% (1)
  • E
    74% (25)

Explanation

The GRANT command with the WITH GRANT OPTION clause allows the grantee to grant object privileges to other users and roles.

Topics

#WITH GRANT OPTION#object privileges#privilege delegation#GRANT

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice