Chapter 14: Managing Adaptive Server Logins, Database Users, and Client Connections

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	Create and run jobs through Job Scheduler
Real Time messaging	messaging_role	Administer and execute Real Time Messaging
Web Services	web_services	Administer Web Services

View this book as PDF