A list of the system privileges and object permissions required to complete the various function tasks.
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:
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:
|
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:
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:
|
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:
External Java function to be owned by any user –
you must have the CREATE EXTERNAL REFERENCE system privilege. You
must also have one of:
|
Database Version | Function Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one of:
|
SAP Sybase IQ 16.0 | You must have one of:
|
Database Version | Function Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | None. |
SAP Sybase IQ 16.0 | None. |
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:
Modify any other function property regardless of type – you must have one of:
|
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:
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:
Modify a comment for any function type – you must have one of:
Modify permissions for any function type – You must have
one of:
|
Database Version | Database Object Privileges |
---|---|
SAP Sybase IQ 15.3 and 15.4 | You must have one
of:
|
SAP Sybase IQ 16.0 | You must have
one of:
|