Sybase Roles

A role is mechanism for assigning groups of privileges to logins. Roles are two types: System Roles and User-defined roles.

Sybase System Roles:

There are 13 System Roles in Sybase. Among these sa_role, sso_role and oper_role. Below are 13 System roles available in Sybase(ASE). ‘sa’ is only login which is having all 13 System roles initially.

Role Function
sa_role Performs system administratioon
sso_role Performs security administration
oper_role Performs operator functions
replication_role Used by replication process
sybase_ts_role Used to perform undocumented maintenance tasks
dtm_tm_role Used in externally coordinated XA transactions
ha_role Controls high availability(HA) companion server actions
mon_role Provide access to monitoring tables
js_admin_role Allows for administration of the job scheduler
js_client_role Execute job scheduler task
js_user_role Execute job scheduler task
messaging_role Administers and executes real-timemessaging
web_services Administers web services

The System Administrator Role(sa_role):
sa_role responsibilities are;

  • Grant or revoke the sa_role.
  • Use the documented dbcc commands.
  • Manage disk resources(device definition, database creation,…..)
  • To configure server parameters.
  • Shutdown the database server.

The Operator Role(oper_role):
oper_role has permission to dump and load all of databases. Database owner can also dump and load the database and logs.
oper_role user doesnot have permissions to create database.

The System Security Officer Role
sso_role has following responsibilities:

  • Creating login accounts which includes assigning initial passwords
  • Changing the password of login.
  • Creating, granting and revoking user-defined roles.
  • Granting and revoking SSO and operator roles.
  • Setting the password and security-related configuration options.
  • Managing audit system.
Powered by k2schools