Filter
Top Products
Tools for system administration
4
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: