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

Procedure Privileges

SAP Sybase IQ 15.3 and 15.4

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

DBA authority.
RESOURCE ADMIN authority.

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

Requires DBA authority.

External C/C++ or External Environment procedure to be owned by self or any user – Requires one of:

DBA authority.

SAP Sybase IQ 16.0

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

Requires CREATE PROCEDURE system privilege.

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

CREATE ANY PROCEDURE system privilege.
CREATE ANY OBJECT system privilege

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

CREATE EXTERNAL REFERENCE system privilege.
CREATE PROCEDURE system privilege.

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

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 – Requires DBA authority.
SAP Sybase IQ 16.0	Remote procedure to be owned by self – Requires CREATE PROCEDURE system privilege. Remote procedure to be owned by any user – Requires 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 –

Requires DBA authority.

SAP Sybase IQ 16.0

Remote procedure to be owned by self –

Requires CREATE PROCEDURE system privilege.

Remote procedure to be owned by any user –

Requires 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	Requires DBA authority.
SAP Sybase IQ 16.0	Table UDF or TPF to be owned by self – Requires all of: CREATE EXTERNAL REFERENCE system privilege. CREATE PROCEDURE system privilege. Table UDF or TPF 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.

Executing a Procedure Using View Data in SQL

Database Version	Procedure Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. You have EXECUTE permission on the procedure. You own the procedure.
SAP Sybase IQ 16.0	Requires 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	Requires one of: DBA authority. You own the procedure.
SAP Sybase IQ 16.0	Requires 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 required.
SAP Sybase IQ 16.0	None required.

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 required. Modify permissions for any procedure type – Requires one of: DBA authority. PERMS ADMIN authority. You own the database object. Modify any other procedure property regardless of type – Requires one of: DBA authority. You own the procedure.
SAP Sybase IQ 16.0	View any procedure property page regardless of type – None required. Modify SQL code for Watcom-SQL or Transcat-SQL procedures – Requires 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 – Requires CREATE EXTERNAL REFERENCE system privilege. Also requires one of: ALTER ANY PROCEDURE system privilege. ALTER ANY OBJECT system privilege. You own the procedure. Modify a comment for any procedure 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 procedure. Modify permissions for any procedure type – Requires 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 required.

Modify permissions for any procedure type – Requires one of:

DBA authority.
PERMS ADMIN authority.
You own the database object.

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

DBA authority.
You own the procedure.

SAP Sybase IQ 16.0

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

Modify SQL code for Watcom-SQL or Transcat-SQL procedures – Requires 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 –

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

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

Modify permissions for any procedure type – Requires 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	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.