Authority-Based Database Object Permissions Privilege Summary

A list of the system privileges and object permissions required to complete the various authority-based user and group tasks pertaining to database objects.

Grant or Revoke Permissions on a Table or Column

Database Version Authority-Based Database Object Permissions
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You have administrative rights (with grant option) to the permission.
  • You own the database object.
SAP Sybase IQ 16.0 Not supported.

Modify Administrative Permissions on a Table or Column

Database Version Authority-Based Database Object Permissions
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the database object.
SAP Sybase IQ 16.0 Not supported.

Grant or Revoke Permissions on a View or Materialized View

Database Version Authority-Based Database Object Permissions
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • Administrative rights over the permission.
  • You own the database object.
SAP Sybase IQ 16.0 Not supported.

Modify Administrative Permissions on a View or Materialized View

Database Version Database Object Privileges
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the database object.
SAP Sybase IQ 16.0 Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege.
  • You have administrative rights to the permission being modified.
  • You own the database object.

Grant or Revoke Permissions on a Sequence Generator

Database Version Authority-Based Database Object Permissions
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the sequence generator.
SAP Sybase IQ 16.0 Not supported.

Grant or Revoke Permissions on a Function or Procedure

Database Version Authority-Based Database Object Permissions
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
  • You own the database object.
SAP Sybase IQ 16.0 Not supported.

Grant or Revoke Permissions on a Dbspace

Database Version Authority-Based Database Object Permissions
SAP Sybase IQ 15.3 and 15.4 Requires one of:
  • DBA authority.
  • PERMS ADMIN authority.
SAP Sybase IQ 16.0 Not supported.
Parent topic: Authority-Based Object Permissions on Users and Groups