Adding an Authority to a Group

Add authorities to allow members of a group to perform specified database operations, such as the ability to manage dbspaces.

Prerequisites
Database Version Authority-Based Group Permissions
SAP Sybase IQ 15.3 and 15.4 Requires 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, select IQ Servers > Security > Authority Based > Groups.
  3. Select a 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.
    The Group 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. Click Apply to save your changes and continue granting authorities, or click OK to save and close the properties view.
Parent topic: Authority-Based Groups
Related tasks
Creating an Authority-Based Group
Deleting an Authority-Based Group
Converting an Authority-Based Group to a User
Adding Authority-Based Users and Groups to Groups
Removing Authority-Based Users or Groups from a Group
Viewing or Modifying Authority-Based Group Options
Generating Authority-Based Group DDL Commands
Viewing or Modifying Authority-Based Group Properties
Removing an Authority from a Group
Authenticating a Login Account for a Managed Resource
Related reference
Authority-Based Group Privilege Summary