Creating and assigning roles to users  System Administrator privileges

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





Copyright © 2005. Sybase Inc. All rights reserved. System Administrator privileges

View this book as PDF