Procedure Privilege Summary

Creating a Procedure

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	Watcom SQL or Transact-SQL procedure to be owned by self – you must have one of: DBA authority RESOURCE ADMIN authority Watcom SQL or Transact-SQL, to be owned by any user – you must have DBA authority External C/C++ or External Environment procedure to be owned by self or any user – you must have DBA authority.
SAP Sybase IQ 16.0	Watcom SQL or Transact-SQL procedure to be owned by self – you must have the CREATE PROCEDURE system privilege. Watcom SQL or Transact-SQL procedure to be owned by any user – you must have one of: CREATE ANY PROCEDURE system privilege CREATE ANY OBJECT system privilege External C/C++ or External Environment procedure to be owned by self – you must have all of: CREATE EXTERNAL REFERENCE system privilege CREATE PROCEDURE system privilege External C/C++ or External Environment procedure 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

Procedure Privileges

SAP Sybase IQ 15.3 and 15.4

Watcom SQL or Transact-SQL procedure to be owned by self – you must have one of:

DBA authority
RESOURCE ADMIN authority

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

External C/C++ or External Environment procedure to be owned by self or any user – you must have DBA authority.

SAP Sybase IQ 16.0

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

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

CREATE ANY PROCEDURE system privilege
CREATE ANY OBJECT system privilege

External C/C++ or External Environment procedure to be owned by self – you must have all of:

CREATE EXTERNAL REFERENCE system privilege
CREATE PROCEDURE system privilege

External C/C++ or External Environment procedure 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 a Remote Procedure

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	Remote procedure to be owned by self or any user – you must have DBA authority.
SAP Sybase IQ 16.0	Remote procedure to be owned by self – you must have the CREATE PROCEDURE system privilege. Remote procedure to be owned by any user – you must have one of: CREATE ANY PROCEDURE system privilege CREATE ANY OBJECT system privilege

Database Version

Procedure Privileges

SAP Sybase IQ 15.3 and 15.4

Remote procedure to be owned by self or any user – you must have DBA authority.

SAP Sybase IQ 16.0

Remote procedure to be owned by self – you must have the CREATE PROCEDURE system privilege.

Remote procedure to be owned by any user – you must have one of:

CREATE ANY PROCEDURE system privilege
CREATE ANY OBJECT system privilege

Creating a Table UDF or TPF

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	You must have DBA authority.
SAP Sybase IQ 16.0	Table UDF or TPF to be owned by self – You must have all of: CREATE EXTERNAL REFERENCE system privilege CREATE PROCEDURE system privilege Table UDF or TPF 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

Executing a Procedure Using View Data in SQL

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority You have EXECUTE permission on the procedure You own the procedure
SAP Sybase IQ 16.0	You must have one of: EXECUTE ANY PROCEDURE system privilege You have EXECUTE permission on the procedure You own the procedure

Deleting a Procedure

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

Generating Procedure DDL Commands

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

Viewing or Modifying Procedure Properties

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	View any procedure property page regardless of type – none. Modify permissions for any procedure type – You must have one of: DBA authority PERMS ADMIN authority You own the database object Modify any other procedure property regardless of type – you must have one of: DBA authority You own the procedure
SAP Sybase IQ 16.0	View any procedure property page regardless of type – none. Modify SQL code for Watcom-SQL or Transcat-SQL procedures – you must have one of: ALTER ANY PROCEDURE system privilege ALTER ANY OBJECT system privilege You own the procedure Modify SQL code for Table UDFs, TPFs, or External Environment procedures – 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 procedure Modify a comment for any procedure 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 procedure Modify permissions for any procedure type – You must have one of: MANAGE ANY OBJECT PRIVILEGE system privilege You own the database object

Database Version

Procedure Privileges

SAP Sybase IQ 15.3 and 15.4

View any procedure property page regardless of type – none.

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

DBA authority
PERMS ADMIN authority
You own the database object

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

DBA authority
You own the procedure

SAP Sybase IQ 16.0

View any procedure property page regardless of type – none.

Modify SQL code for Watcom-SQL or Transcat-SQL procedures – you must have one of:

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

Modify SQL code for Table UDFs, TPFs, or External Environment procedures – 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 procedure

Modify a comment for any procedure 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 procedure

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

MANAGE ANY OBJECT PRIVILEGE system privilege
You own the database object

Granting or Revoking Procedure 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