Removing an Authority from an Authority-Based User

Remove a user's ability to perform specific authorized database operations.

Prerequisites
Database Version Authority-Based User 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 > 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. Clear the check box beside the authorities you want to revoke from the user.
  6. Click Apply to save your changes and keep revoking authorities, or click OK to save and close the properties view.
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
Adding an Authority to an Authority-Based User
Authenticating a Login Account for a Managed Resource
Related reference
Authority-Based User Privilege Summary