introduction to sybase DBA

• Even though the process of SYBASE DBA has common work tasks for all types of applications running on top of Sybase. but SYBASE DBA need to have an overview about the applications to boost up the performance and other application specific activities.

• Roles Required for System Administration Tasks: To perform system administration for SAP ASE the follow 4 roles are required. which are the integration of security, administration and operational tasks are grouped into the following roles:

1.  sa_role
2. sso_role
3. sybase_ts_role
4. oper_role   

Note: oper_role  is responsible for all types of backup(dump database, dump transaction, load database, load transaction) activities.

• In addition, two users are classified based on their objects in Sybase DB:

1. database owner.
2. database object owner.

1.Database owner: The database owner is the creator of a database.

 A system administrator can use the grant command to grant users the authority to create databases.

A database owner can run:   

•  sp_adduser to allow other SAP ASE users access to the database.
• Use the grant command to give other users permission to create objects and execute commands within the database.

Note:

The database owner does not automatically receive permissions on objects owned by other users. However, a database owner can temporarily assume the permissions of other users in the database at any time by using the setuser command. Using a combination of the setuser and grant commands, the database owner can acquire permissions on any object in the database.

2.Database object owner: A database object owner is a user who creates a database object.

Database objects include tables, indexes, views, defaults, triggers, rules, constraints, and procedures. Before a user can create a database object, the database owner must grant the user permission to create objects of a particular type.

There is no special login name or password for a database object owner.
The database object owner creates an object using the appropriate create statement, and then grants permission to other users.

s use the setuser command to impersonate any other user in the database, including the object owner.

Note: need to create a database user by using security guide of sybase.