This section describes how to grant permissions to users and create new users using Interactive SQL 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 Login Management facility.
To add and modify users with Sybase IQ Login Management, use the system procedures described in “Managing 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 Interactive SQL 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 Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures. The ASE stored procedures do not let you use the Sybase IQ Login Management facilities for limiting connections.
