Function Privilege Summary

Creating a Watcom SQL or Transact-SQL Function

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	Watcom SQL or Transact-SQL function to be owned by self – Requires one of: DBA authority. RESOURCE ADMIN authority. Watcom SQL or Transact-SQL function to be owned by any user – Requires DBA authority.
SAP Sybase IQ 16.0	Watcom SQL or Transact-SQL to be owned by self – Requires CREATE PROCEDURE system privilege. Watcom SQ or Transact-SQL function to be owned by any user – Requires one of: CREATE ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege.

Database Version

Function Privileges

SAP Sybase IQ 15.3 and 15.4

Watcom SQL or Transact-SQL function to be owned by self – Requires one of:

Watcom SQL or Transact-SQL function to be owned by any user –

SAP Sybase IQ 16.0

Watcom SQL or Transact-SQL to be owned by self –

Watcom SQ or Transact-SQL function to be owned by any user –

Requires one of:

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	External C/C++ Scalar or Aggregate function to be owned by self or any user – Requires DBA authority.
SAP Sybase IQ 16.0	External C/C++ Scalar or Aggregate function to be owned by self – Requires all of: CREATE PROCEDURE system privilege. CREATE EXTERNAL REFERENCE system privilege. External C/C++ Scalar or Aggregate function to be owned by any user – Requires CREATE EXTERNAL REFERENCE system privilege. Also requires one of: CREATE ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege.

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	External Java function to be owned by self or any user – Requires DBA authority.
SAP Sybase IQ 16.0	External Java function to be owned by self – Requires all of: CREATE PROCEDURE system privilege. CREATE EXTERNAL REFERENCE system privilege. External Java function to be owned by any user – Requires CREATE EXTERNAL REFERENCE system privilege. Also requires one of: CREATE ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege.

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. You own the function.
SAP Sybase IQ 16.0	Requires one of: DROP ANY PROCEDURE system privilege. DROP ANY OBJECT system privilege. You own the function.

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

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	View any function property page regardless of type – None required. Modify permissions for any function type – Requires one of: DBA authority. PERMS ADMIN authority. You own the database object. Modify any other function property regardless of type – Requires one of: DBA authority. You own the function.
SAP Sybase IQ 16.0	View any function property page regarless of type – None required. Modify SQL code for Watcom SQL or Transact-SQL function – Requires one of: ALTER ANY PROCEDURE system privilege. ALTER ANY OBJECT system privilege. You own the function. Modify SQL code for External C/C++ Scalar or Aggregate, or External Java function – Requires one of: Requires CREATE EXTERNAL REFERENCE system privilege. Also requires one of: ALTER ANY PROCEDURE system privilege. ALTER ANY OBJECT system privilege. You own the function. Modify a comment for any function type – Requires one of: CREATE ANY PROCEDURE system privilege. ALTER ANY PROCEDURE system privilege. CREATE ANY OBJECT system privilege. ALTER ANY OBJECT system privilege. COMMENT ANY OBJECT system privilege. You own the function. Modify permissions for any function type – Requires one of: MANAGE ANY OBJECT PRIVILEGE system privilege. You own the database object.

Database Version

Function Privileges

SAP Sybase IQ 15.3 and 15.4

View any function property page regardless of type – None required.

Modify permissions for any function type – Requires one of:

Modify any other function property regardless of type – Requires one of:

SAP Sybase IQ 16.0

View any function property page regarless of type – None required.

Modify SQL code for Watcom SQL or Transact-SQL function – Requires one of:

Modify SQL code for External C/C++ Scalar or Aggregate, or External Java function – Requires one of:

Requires CREATE EXTERNAL REFERENCE system privilege.
Also requires one of:
- ALTER ANY PROCEDURE system privilege.
- ALTER ANY OBJECT system privilege.
- You own the function.

Modify a comment for any function type – Requires one of:

Modify permissions for any function type – Requires one of:

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 own the database object.