Viewing Login Mapping Properties

Display the properties for the selected login mapping.

Prerequisites
Database Version Login Mapping Privileges
SAP Sybase IQ 15.3 and 15.4 View Login Mapping properties – you must have SELECT permission on the SYSLOGINMAP view.

Modify Login Mapping comment – you must have one of:

  • DBA authority
  • USER ADMIN authority along with SELECT permission on the SYSLOGINMAP view
SAP Sybase IQ 16.0 View any login mapping property page – you must have one of:
  • SELECT ANY TABLE system privilege
  • SELECT permission on the SYSLOGINMAP view
Modify a login mapping comment – you must have the MANAGE ANY USER system privilege along with one of:
  • SELECT ANY TABLE system privilege
  • SELECT permission on the SYSLOGINMAP view
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Security, and then select Login Mappings.
    Note: If you do not have the SELECT ANY TABLE system privilege or SELECT permission on the SYSLOGINMAP view, the list of login mappings is empty.
  3. Select a login mapping 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 Login Mapping Properties view appears. You may edit the Comment section, but the rest of the property page is read-only.
  4. 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.
Related tasks
Creating a Login Mapping
Deleting a Login Mapping
Generating Login Mapping DDL Commands
Authenticating a Login Account for a Managed Resource
Related reference
Login Mapping Privilege Summary