Adding an Authority to an Authority-Based User

Add authorities to a user to allow him or her to perform specified database operations, such as the ability to manage dbspaces.

Prerequisites
Database Version Authority-Based User Permissions
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • PERMS ADMIN authority
SAP Sybase IQ 16.0 Not supported.
Task
  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. 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. In the left pane, click Authorities.
  5. In the right pane, select one or more authorities:
    Authority Description
    Backup Grants the ability to perform database backups.
    DBA Grants the ability fully administer the database.
    Multiplex Admin Grants the ability for Multiplex server administration
    Operator Grants the ability to backup and checkpoint databases, perform system monitoring, and drop connections.
    Perms Admin Grants the ability to manage data permission, groups, authorities, and passwords.
    Profile Grants the ability to perform application and procedure profiling, request log creation and analysis, and by the Index Consultant.
    Read client file Grants the ability to read from a file on the client computer, for example when loading data.
    Read file Grants the ability to the group to execute SELECT statements against a file using the OPENSTRING clause.
    Remote DBA Grants Remote DBA authority to any table the group 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 the ability to create database objects.
    Space Admin Grants the ability to perform dbspace management (including CREATE permission) and read-only selective database restoration.
    User Admin Grants the ability to manage users, external logins, and login policies management.
    Validate Grants the ability to validate tables, materialized views, and indexes.
    Write client file Grants the ability to write to a file on the client computer, for example when downloading data.
  6. 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: Authority-Based Users
Related tasks
Creating an Authority-Based User
Deleting an Authority-Based User
Converting an Authority-Based User to a Group
Viewing or Modifying Authority-Based User Options
Generating Authority-Based User DDL Commands
Viewing or Modifying Authority-Based User Properties
Changing an Authority-Based User Password
Forcing an Authority-Based User to Change their Password
Unlocking an Authority-Based User Account
Changing an Authority-Based User Login Policy
Removing an Authority from an Authority-Based User
Authenticating a Login Account for a Managed Resource
Related reference
Authority-Based User Privilege Summary