The DBMS SERVER MANAGEMENT privileges
AuraDB Business CriticalAuraDB Virtual Dedicated CloudEnterprise Edition

The DBMS privileges for server management can be granted, denied, or revoked like other privileges.

For more details about the syntax descriptions, see Reading the administration commands syntax.
Table 1. Server management privileges command syntax
Command Description 
GRANT [IMMUTABLE] SERVER MANAGEMENT
  ON DBMS
  TO role[, ...]

Enables the specified roles to show, enable, rename, alter, reallocate, deallocate, and drop servers.

 
GRANT [IMMUTABLE] SHOW SERVERS
  ON DBMS
  TO role[, ...]

Enables the specified roles to show servers.

Grant privilege to manage servers

You can grant the privilege to show, enable, rename, alter, reallocate, deallocate, and drop servers using the SERVER MANAGEMENT privilege.
For example:

GRANT SERVER MANAGEMENT ON DBMS TO serverManager;

As a result, the serverManager role has all privileges to manage servers. To list all privileges for the role serverManager as commands, use the following query:

SHOW ROLE serverManager PRIVILEGES AS COMMANDS;
Table 2. Result
command

"GRANT SERVER MANAGEMENT ON DBMS TO `serverManager`"

Rows: 1

Grant privilege to show servers

You can grant the privilege to show servers using the SHOW SERVERS privilege.
For example:

GRANT SHOW SERVERS ON DBMS TO serverViewer;

As a result, the serverViewer role has privileges that only allow showing servers. To list all privileges for the role serverViewer as commands, use the following query:

SHOW ROLE serverViewer PRIVILEGES AS COMMANDS;
Table 3. Result
command

"GRANT SHOW SERVERS ON DBMS TO `serverViewer`"

Rows: 1