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: