System administration authority (SYSADM)
The SYSADM authority level is the highest
level of administrative authority at the instance level. Users with
SYSADM authority can run some utilities and issue some database and
database manager commands within the instance.
System control authority (SYSCTRL)
SYSCTRL authority is the highest level of system control
authority. This authority provides the ability to perform maintenance
and utility operations against the database manager instance and its
databases. These operations can affect system resources, but they
do not allow direct access to data in the databases.
System maintenance authority (SYSMAINT)
SYSMAINT authority is the second level of system control
authority. This authority provides the ability to perform maintenance
and utility operations against the database manager instance and its
databases. These operations can affect system resources, but they
do not allow direct access to data in the databases.
System monitor authority (SYSMON)
SYSMON authority provides the ability to take database
system monitor snapshots of a database manager instance or its databases.