Creating an Authority-Based User

Add a new user to the database using the Create User wizard.

1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
2. In the left pane, expand IQ Servers > Security > Authority-Based, and then select Users.
3. Click the arrow next to Users and select New.
   The Create User Wizard appears.
4. On the Welcome page, specify

   Option	Description
   Select a resource for which the user will be created:	Select a resource from the list. Note: If the selected resource does not support authority-based security, an error message appears.
   What do you want to name the new user?	Enter a name for the new user.

5. Click Next.
6. On the Specify a Password page:

   Option	Description
   Enable password	Allows the user 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. Characters appear as asterisks.
   Confirm password	Confirms the password. The contents of the two password fields must match exactly.
   Requires password change on next login	Forces the user to change the password at the next login.
   Login policy	Select a login policy from the list.

7. Click Next.
8. (Optional) On the Select Authorities page, select one or more the authorities you want to assign to the new user:

   Authority	Description
   Backup	Allows this user to back up the database.
   DBA	Grants DBA authority to administer the database.
   Multiplex Admin	Grants Multiplex Admin authority to the user; Multiplex Admin authority allows a user to perform multiplex administration tasks.
   Operator	Grants Operator authority to the user; Operator authority lets a user checkpoint databases, drop connections, backup databases, and monitor the system.
   Perms Admin	Grants Perms Admin authority to the user; Perms Admin authority lets a user manage data permissions, groups, authorities, and passwords.
   Profile	Allows this user 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 to read from a file on the client computer.
   Read file	Grants Read file authority to the user, allowing the user to execute SELECT statements against a file using the OPENSTRING clause.
   Remote DBA	Grants Remote DBA authority to any table the user 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; resource authority lets a user create database objects.
   Space Admin	Grants Space Admin authority to the user; Space Admin authority lets a user manage dbspaces.
   User Admin	Grants User Admin authority to the user; User Admin authority lets a user manage users, external logins, and login policies.
   Validate	Allows this user to validate tables, materialized views, and indexes.
   Write client file	Allows this user to write to a file on the client computer.

9. Click Next.
10. (Optional) On the Specify a comment page, enter a comment for this user.
11. Click Finish.