DB File Privilege Summary

A list of the system privileges and object permissions required to complete the various DB file tasks.

Creating a DB File

Database Version	DB File Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SPACE ADMIN authority
SAP Sybase IQ 16.0	You must have the MANAGE ANY DBSPACE system privilege.

Database Version	DB File Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SPACE ADMIN authority
SAP Sybase IQ 16.0	You must have the MANAGE ANY DBSPACE system privilege.

Database Version	DB File Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority SPACE ADMIN authority
SAP Sybase IQ 16.0	You must have the MANAGE ANY DBSPACE system privilege.

Database Version	DB File Privileges
SAP Sybase IQ 15.3 and 15.4	None.
SAP Sybase IQ 16.0	None.

Database Version	DB File Privileges
SAP Sybase IQ 15.3 and 15.4	View any db file property page – none. Modify any db file property – you must have one of: DBA authority SPACE ADMIN authority
SAP Sybase IQ 16.0	View any db file property page – none. Modify any db file property – you must have the MANAGE ANY DBSPACE system privilege.

Database Version

DB File Privileges

SAP Sybase IQ 15.3 and 15.4

View any db file property page – none.

Modify any db file property – you must have one of:

SAP Sybase IQ 16.0

View any db file property page – none.

Modify any db file property – you must have the MANAGE ANY DBSPACE system privilege.

Database Version	Database Object Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority PERMS ADMIN authority
SAP Sybase IQ 16.0	You must have the MANAGE ANY DBSPACE system privilege.