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	Requires one of: DBA authority. SPACE ADMIN authority.
SAP Sybase IQ 16.0	Requires MANAGE ANY DBSPACE system privilege.

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

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

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

Database Version	DB File Privileges
SAP Sybase IQ 15.3 and 15.4	View any db file property page – None required. Modify any db file property – Requires one of: DBA authority. SPACE ADMIN authority.
SAP Sybase IQ 16.0	View any db file property page – None required. Modify any db file property – Requires 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 required.

Modify any db file property – Requires one of:

SAP Sybase IQ 16.0

View any db file property page – None required.

Modify any db file property – Requires MANAGE ANY DBSPACE system privilege.

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