Sybase 12.4.2 manual Tools for system administration, Types of users, Granting permissions

Tools for system administration

Types of users

Adaptive Server IQ recognizes three categories of users for each IQ database:

•The database administrator, or DBA, has complete authority to perform all operations on that database. This guide is addressed primarily to the DBA, who typically carries out most administrative tasks.

•The user who creates a particular database object is its owner, and can perform any operation on that object.

•All other users are considered public users. The owner of an object is considered a public user for objects owned by other users.

Granting permissions

Except for the DBA, who can perform any task, users must be granted the authority to perform specific tasks. For example, you need the proper authority to:

•Connect to a database.

•Create database objects, such as a database, table, or index.

•Alter the structure of database objects.

•Insert or delete data.

•Select (view) data.

•Execute procedures.

The DBA can grant any type of authority to any user. Sometimes other users can grant authority as well. For more information on what users can do, and how the DBA manages users, see Chapter 10, “Managing User IDs and Permissions”.

Tools for system administration

To help you manage your database, Adaptive Server IQ provides two primary tools:

4