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 – you must have one of: DBA authority RESOURCE ADMIN authority Watcom SQL or Transact-SQL function to be owned by any user – you must have DBA authority.
SAP Sybase IQ 16.0	Watcom SQL or Transact-SQL to be owned by self – you must have the CREATE PROCEDURE system privilege. Watcom SQ or Transact-SQL function to be owned by any user – you must have 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 – you must have one of:

DBA authority
RESOURCE ADMIN authority

Watcom SQL or Transact-SQL function to be owned by any user – you must have DBA authority.

SAP Sybase IQ 16.0

Watcom SQL or Transact-SQL to be owned by self – you must have the CREATE PROCEDURE system privilege.

Watcom SQ or Transact-SQL function to be owned by any user – you must have one of:

CREATE ANY PROCEDURE system privilege
CREATE ANY OBJECT system privilege

Creating an External C/C++ Scalar or Aggregate Function

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 – you must have DBA authority.
SAP Sybase IQ 16.0	External C/C++ Scalar or Aggregate function to be owned by self – you must have all of: CREATE PROCEDURE system privilege CREATE EXTERNAL REFERENCE system privilege External C/C++ Scalar or Aggregate function to be owned by any user – you must have the CREATE EXTERNAL REFERENCE system privilege. You must also have 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 C/C++ Scalar or Aggregate function to be owned by self or any user – you must have DBA authority.

SAP Sybase IQ 16.0

External C/C++ Scalar or Aggregate function to be owned by self – you must have all of:

CREATE PROCEDURE system privilege
CREATE EXTERNAL REFERENCE system privilege

External C/C++ Scalar or Aggregate function to be owned by any user – you must have the CREATE EXTERNAL REFERENCE system privilege. You must also have one of:

CREATE ANY PROCEDURE system privilege
CREATE ANY OBJECT system privilege

Creating an External Java Function

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

Deleting a Function

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

Generating Function DDL Commands

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

Viewing or Modifying Function Properties

Database Version	Function Privileges
SAP Sybase IQ 15.3 and 15.4	View any function property page regardless of type – none. Modify permissions for any function type – You must have one of: DBA authority PERMS ADMIN authority You own the database object Modify any other function property regardless of type – you must have one of: DBA authority You own the function
SAP Sybase IQ 16.0	View any function property page regardless of type – none. Modify SQL code for Watcom SQL or Transact-SQL function – you must have 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 – you must have the CREATE EXTERNAL REFERENCE system privilege. You must also have one of: ALTER ANY PROCEDURE system privilege ALTER ANY OBJECT system privilege You own the function Modify a comment for any function type – you must have 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 – You must have 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.

Modify permissions for any function type – You must have one of:

DBA authority
PERMS ADMIN authority
You own the database object

Modify any other function property regardless of type – you must have one of:

DBA authority
You own the function

SAP Sybase IQ 16.0

View any function property page regardless of type – none.

Modify SQL code for Watcom SQL or Transact-SQL function – you must have 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 – you must have the CREATE EXTERNAL REFERENCE system privilege. You must also have one of:

ALTER ANY PROCEDURE system privilege
ALTER ANY OBJECT system privilege
You own the function

Modify a comment for any function type – you must have 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 – You must have one of:

MANAGE ANY OBJECT PRIVILEGE system privilege
You own the database object

Granting or Revoking Function EXECUTE Permission

Database Version	Database Object Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority PERMS ADMIN authority You own the database object
SAP Sybase IQ 16.0	You must have one of: MANAGE ANY OBJECT PRIVILEGE system privilege You own the database object