Sybase IQ provides security controls by means of the privileges you can assign to users.
The database administrator (DBA) is responsible for maintaining database security.
Sybase IQ recognizes three categories of users for each Sybase IQ database: DBA, owner, and public users.
The database administrator, or DBA, has complete authority to perform all operations on that database. The DBA 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.
Except for the DBA, who can perform any task, users must be granted the authority to perform specific tasks.
Connect to a database
Create database objects, such as a database, table, index, or foreign key
Place objects on specific dbspaces
Alter the structure of database objects
Insert, update, or delete data
Select (view) data
Execute procedures