You create a role with the following command: CREATE ROLE "InfoUser" When you try to assign this role to user PETER with the following command:

GRANT InfoUser to PETER you receive an error message "Invalid user privilege:

INFOUSER". What must you do to avoid this problem? (Choose three)

Question

You create a role with the following command: CREATE ROLE "InfoUser" When you try to assign this role to user PETER with the following command:

GRANT InfoUser to PETER you receive an error message "Invalid user privilege:

INFOUSER". What must you do to avoid this problem? (Choose three)

Accepted Answer

A. Recreate the role with the command CREATE ROLE InfoUser. D. Recreate the role with the command CREATE ROLE INFOUSER. E. Grant the role with the command GRANT "InfoUser" to PETER.

Answer

B. Recreate user PETER with GRANT OPTION.

Answer

C. Grant the role the WITH ADMIN OPTION.

You create a role with the following command: CREATE ROLE "InfoUser" When you try to assign this role to user PETER with the following command: GRANT InfoUser to PETER you receive an error message…

Question

Options

How the community answered

Community Discussion