Viewing Properties for Sybase IQ Users or Groups

View the details of login parameters and authorities for users or groups.

Prerequisites

User Admin authority is required.

Task

In the Perspective Resources view, select a resource.
From the application menu bar, select View > Open > Administration Console.
In the left pane of the Administration Console, select Security > Users or Security > Groups.
Select the user or group from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties

Area	Description
General tab	Name – name of the user or group. Enable Password – allows the user or group to connect to the database with password security. Clearing this option disables the Password and Confirm Password options. Password – the password for the user or group. Characters appear as asterisks. Confirm password – a field for confirming the password that you typed in the Password text box. The contents of the two fields must match exactly. Password creation time – date and time when the password was created. Change password on next login – force the user or group to change the password at the next login. Login policy – select the login policy that applies for this user or group. Last login time – last time the user successfully logged in. Failed login attempts – number of times the user has tried to log in with an incorrect password. Locked – displays false if the account is unlocked. Displays true if the user or group has exceeded the allowed number of failed login attempts. Unlock now – unlocks the account if Locked is true. Comment – a text field for adding an optional comment about the user or group.
Authorities tab	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; a user or group with Multiplex Admin authority can perform multiplex administration tasks. Operator - grants Operator authority to the user or group; a user or group with Operator authority can checkpoint databases, drop connections, backup databases, and monitor the system. Perms Admin - grants Perms Admin authority to the user or group; a user or group with Perms Admin authority can 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 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 have access to. 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; a user or group with resource authority can create database objects. Space Admin - grants Space Admin authority to the user or group; a user or group with Space Admin authority can manage dbspaces. User Admin - grants User Admin authority to the user or group; a user or group with User Admin authority can manage users, external logins, and login policies. Validate - allows this user or group to validate tables, materialized views, and indexes. Note: Materialized views are only supported for SQL Anywhere tables in the IQ catalog store. Write client file - allows this user to write to a file on the client computer.

Area

Description

General tab

Name – name of the user or group.

Enable Password – allows the user or group to connect to the database with password security. Clearing this option disables the Password and Confirm Password options.

Password – the password for the user or group. Characters appear as asterisks.

Confirm password – a field for confirming the password that you typed in the Password text box. The contents of the two fields must match exactly.

Password creation time – date and time when the password was created.

Change password on next login – force the user or group to change the password at the next login.

Last login time – last time the user successfully logged in.

Failed login attempts – number of times the user has tried to log in with an incorrect password.

Locked – displays false if the account is unlocked. Displays true if the user or group has exceeded the allowed number of failed login attempts.

Unlock now – unlocks the account if Locked is true.

Comment – a text field for adding an optional comment about the user or group.

Authorities tab

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; a user or group with Multiplex Admin authority can perform multiplex administration tasks.

Operator - grants Operator authority to the user or group; a user or group with Operator authority can checkpoint databases, drop connections, backup databases, and monitor the system.

Perms Admin - grants Perms Admin authority to the user or group; a user or group with Perms Admin authority can 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 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 have access to. 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; a user or group with resource authority can create database objects.

Space Admin - grants Space Admin authority to the user or group; a user or group with Space Admin authority can manage dbspaces.

User Admin - grants User Admin authority to the user or group; a user or group with User Admin authority can manage users, external logins, and login policies.

Validate - allows this user or group to validate tables, materialized views, and indexes.

Note: Materialized views are only supported for SQL Anywhere tables in the IQ catalog store.

Write client file - allows this user to write to a file on the client computer.