System-defined roles

Table 14-4 lists the system roles, the value to use for the role_granted option of the grant role or revoke role command, and the tasks usually performed by a person with that role.

Table 14-4: System roles and related tasks

Role

Value for role_granted

Description

System administrator

sa_role

Manages and maintains Adaptive Server databases and disk storage

System security officer

sso_role

Performs security-related tasks

Operator

oper_role

Backs up and loads databases server-wide

Sybase Technical Support

sybase_ts_role

Analysis and repair of database structures

Replication

replication_role

Replicate user data

Distributed transaction manager

dtm_tm_role

Coordinate transactions across servers

High availability

ha_role

Administer and execute failover

Monitor and diagnosis

mon_role

Administer and execute performance and diagnostic monitoring

Job Scheduler administration

js_admin_role

Administer Job Scheduler

Job Scheduler user

js_user_role, js_client_role

Create and run jobs through Job Scheduler

Real-time messaging

messaging_role

Administer and executer real-time messaging

Web Services

webservices_role

Administer Web services

Key custodian

keycustodian_role

Create and manage encryption keys