Granting and Revoking Administrative Privileges

Use the GRANT statement to grant administrative privileges. Use the REVOKE statement to revoke administrative privileges.

cisco certification malaysia

To grant the SYSDBA, SYSOPER, SYSBACKUP, SYSDG, or SYSKM administrative privilege to a user:

• Run the GRANT statement.

o revoke the administrative privilege from a user:

• Run the REVOKE statement.

checkpoint certification malaysia

The WITH ADMIN OPTION is ignored if it is specified in the GRANT statement that grants an administrative privilege, and the following rules apply:

• A user currently connected as SYSDBA can grant any administrative privilege to another user and revoke any administrative privilege from another user.
• A user currently connected as SYSOPER cannot grant any administrative privilege to another user and cannot revoke any administrative privilege from another user.
• A user currently connected as SYSBACKUP can grant or revoke another user’s SYSBACKUP administrative privilege.
• A user currently connected as SYSDG can grant or revoke another user’s SYSDG administrative privilege.
• A user currently connected as SYSKM can grant or revoke another user’s SYSKM administrative privilege.

aws certification malaysia

Administrative privileges cannot be granted to roles, because roles are available only after database startup. Do not confuse the database administrative privileges with operating system roles.

virtualization training courses malaysia