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.

Modify a password – you must have the CHANGE PASSWORD system privilege.

Modify a login policy, comment, or refresh DN – you must have the MANAGE ANY USER system privilege.

Refresh LDAP DN - You must have the 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, expand IQ Servers > Security > Role-Based, and then select 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 you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
    • If you do not have privileges to modify properties, SAP 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 SAP Control Center. When logging in to SAP 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 SAP 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.
  5. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Parent topic: Role-Based Users
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