Manage Users and Groups

Add, change, and delete users, or groups containing users and/or other groups, as a prerequisite to managing user authorities.

Both users and groups are objects within the database. Groups are also containers for containing users and other groups. Think of a group as a user ID with special permissions, such as the ability to have members. You grant and revoke authorities for a group in exactly the same manner as you do for users.

For most databases, manage authorities by using groups, rather than by assigning authorities to individual users one at a time.

• Viewing Properties for Sybase IQ Users or Groups
  View the details of login parameters and authorities for users or groups.
• Adding a Sybase IQ User or Group
  Add a new user to the database using the Create User wizard. Add a new group to the database using the Create Group wizard. The two wizards are identical.
• Deleting a Sybase IQ User
  Delete a user from the database.
• Deleting a Sybase IQ Group
  Delete a group from the database.
• Adding a Member to a Sybase IQ Group
  Add a group member to the current group, or add the current group to a higher-level parent group.
• Removing a Sybase IQ User from a Group
  Remove a user or group from the current group.
• Changing a Sybase IQ User to a Group
  Change an existing user into a group that retains the user’s authorities.
• Changing a Sybase IQ Group to a User
  Change an existing group into a user.
• Generating DDL Commands for Sybase IQ Users or Groups
  Display the SQL data description language for creating a user or group. The SQL code can be a useful reference and training tool.