Administrative Privileges

Microsoft windows server certification training courses malaysia

Administrative privileges that are required for an administrator to perform basic database operations are granted through special system privileges.

red hat certified system administrator rhcsa malaysia

These privileges are:

  • SYSDBA
  • SYSOPER
  • SYSBACKUP
  • SYSDG
  • SYSKM
  • SYSRAC

Excluding the SYSRAC privilege, grant these privileges to users depending upon the level of authorization they require. The SYSRAC privilege cannot be granted to users because it is used only by the Oracle agent of Oracle Clusterware to connect to the database using operating system authentication.

agile project management certification training courses malaysia

Starting with Oracle Database 12c Release 1 (12.1), the SYSBACKUPSYSDG, and SYSKM administrative privileges are available. Starting with Oracle Database 12c Release 2 (12.2), the SYSRAC administrative privilege is available. Each new administrative privilege grants the minimum required privileges to complete tasks in each area of administration. The new administrative privileges enable you to avoid granting SYSDBA administrative privilege for many common tasks.

red hat certified specialist in red hat enterprise Linux diagnostics and troubleshooting malaysia

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *