Which commands can be performed by a user with the ORGADMIN role but not the ACCOUNTADMIN role? (Choose two.)

Question

Options

• ASHOW REGIONS;
• BSHOW USERS;
• CSHOW ORGANIZATION ACCOUNTS;
• DGRANT ROLE ORGADMIN TO USER <username>;
• ESELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER (

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

Explanation

The ORGADMIN role is a special system role that is responsible for managing operations at the organization level, such as creating and viewing accounts, enabling database replication, and setting global account parameters. The ACCOUNTADMIN role is a system role that is responsible for managing operations at the account level, such as creating and managing users, roles, warehouses, databases, and shares. Therefore, the commands that can be performed by the ORGADMIN role but not the ACCOUNTADMIN role are: - SHOW ORGANIZATION ACCOUNTS: This command lists all the accounts in the organization and their properties, such as region, edition, and status. The ACCOUNTADMIN role can only show the current account and its properties using the SHOW ACCOUNTS command. - SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER: This function sets a global account parameter for an account in the organization, such as enabling account database replication. The ACCOUNTADMIN role can only set local account parameters using the ALTER ACCOUNT command.

No community discussion yet for this question.