Viewing or Modifying Role-Based User Properties

View or change user properties such as password, login policy and database object permissions.

Prerequisites
Database Version Role-Based User Privileges
SAP Sybase IQ 15.3 and 15.4 Not Supported.
SAP Sybase IQ 16.0

View any user property page – None required.

Modify a password – Requires CHANGE PASSWORD system privilege.

Modify a login policy, comment, or refresh DN – Requires MANAGE ANY USER system privilege.

Refresh LDAP DN - Requires MANAGE ANY USER system privilege.

For privileges relating to user permissions, see:
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane, select IQ Servers > Security > Role-Based > Users.
  3. Select a user 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.
    The User Properties view appears
  4. View or edit the properties.
    • When modifying properties, clicking Apply before changing screens is not necessary, but will save any changes.
    • If you do not have privileges to modify properties, Sybase Control Center displays the properties view in read-only mode.
    Area Description
    General

    Name – (Read only) Name of the user.

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

    Password – The password for the user. 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 – Select to force the user to change the password at the next login.
    Note: This functionality is not currently implemented in Sybase Control Center. When logging in to Sybase Control Center, a user will not be prompted to change their password. He or she will be prompted, however, when logging in to SAP Sybase IQ outside of Sybase Control Center (for example, using Interactive SQL).

    Login policy – Select a login policy for the user from the list.

    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 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.

    LDAP Refresh the user DN.
    Permission

    See Role-Based User and Role Object Permissions.

Related tasks
Creating a Role-Based User
Deleting a Role-Based User
Converting a Role-Based User to a User-Extended Role
Adding a Role to a Role-Based User
Changing a Role-Based User's Administrative Rights on a Role
Removing a Role from a Role-Based User
Adding a System Privilege to a Role-Based User
Changing a User's Administrative Rights on a System Privilege
Removing a System Privilege from a Role-Based User
Viewing or Modifying Role-Based User Options
Generating Role-Based User DDL Commands
Changing a Role-Based User Password
Forcing a Role-Based User to Change their Password
Unlocking a Role-Based User Account
Changing a Role-Based User Login Policy
Authenticating a Login Account for a Managed Resource
Related reference
Role-Based User Privilege Summary