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.
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 execute Real Time Messaging |
Web Services |
webservices_role |
Administer Web Services |
Key custodian |
keycustodian_role |
Creates and manages encryption keys |