This section describes how to grant permissions to users and create new users using DBISQL and Sybase Central. For most databases, the bulk of permission management should be carried out using groups, rather than by assigning permissions to individual users one at a time. However, as groups are simply a user ID with special properties attached, you should read and understand this section before moving on to the discussion of managing groups.
You can also create new users using IQ system procedures. You must use those procedures to add users and modify their passwords and other login capabilities, in order to manage those users with the Sybase IQ User Administration facility.
To add and modify users with Sybase IQ User Administration, use the system procedures described in “Managing IQ user accounts and connections”.
To grant users permissions on database objects, you must still use the commands and procedures described in the rest of this section.
This chapter explains how to manage users and groups using DBISQL and Sybase Central. You can perform many of the same tasks using Adaptive Server Enterprise-compatible stored procedures. If you have previously used Adaptive Server Enterprise or pre-Version 12.0 Sybase IQ, you may prefer to use these stored procedures. For details, see “Adaptive Server Enterprise system and catalog procedures”. The ASE stored procedures do not let you use the Sybase IQ User Administration facilities for limiting connections.
