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.

1. In the Perspective Resources view, select a resource.
2. From the application menu bar, select View > Open > Administration Console.
3. In the left pane of the Administration Console, select IQ Servers > Security > Users or IQ Servers > Security > Groups.
4. Select Users or Groups, hover the mouse pointer over the selection, click the arrow, and select New.
5. On the Welcome page of the wizard, select a server.
6. Enter a name for the new user or group, then click Next.
   Note: Using the Next button is optional. You can also navigate through the wizard by selecting wizard pages from the left pane.
7. On the Specify a Password page, specify:

   Option	Description
   Enable password	Allows the user or group to connect to the database with password security. Leave this option unselected to disable the password and confirm password options.
   Password	The password for the user or group. Characters appear as asterisks.
   Confirm password	Confirms the password. The contents of the two password fields must match exactly.
   Change password on next login	Forces the user or group to change the password at the next login.
   Login policy	List of available login policies.

8. Click Next.
   The Select authorities page of the wizard appears.
9. Select the authorities you want to assign to the new user or group:

   Option	Description
   Backup	Allows this user or group to back up the database.
   DBA	Grants DBA authority to administer the database.
   Multiplex Admin	Grants Multiplex Admin authority to the user or group; Multiplex Admin authority allows a user or group to perform multiplex administration tasks.
   Operator	Grants Operator authority to the user or group; Operator authority lets a user or group checkpoint databases, drop connections, backup databases, and monitor the system.
   Perms Admin	Grants Perms Admin authority to the user or group; Perms Admin authority lets a user or group manage data permissions, groups, authorities, and passwords.
   Profile	Allows this user or group to perform application and procedure profiling, and request log creation, and analysis. Profile authority is also required by the index consultant.
   Read client file	Allows this user or group to read from a file on the client computer.
   Read file	Grants Read file authority to the user or group, allowing the user or group to execute SELECT statements against a file using the OPENSTRING clause.
   Remote DBA	Grants Remote DBA authority to any table the user or group can access. To ensure that actions are secure, run the SQL Remote Message agent using a user ID with this type of authority.
   Resource	Grants resource authority to the user or group; resource authority lets a user or group create database objects.
   Space Admin	Grants Space Admin authority to the user or group; Space Admin authority lets a user or group manage dbspaces.
   User Admin	Grants User Admin authority to the user or group; User Admin authority lets a user or group manage users, external logins, and login policies.
   Validate	Allows this user or group to validate tables, materialized views, and indexes.
   Write client file	Allows this user or group to write to a file on the client computer.

10. Click Next.
11. (Optional) Enter a comment for this user or group.
12. Click Finish.