Several of the new 12.7 stored procedures have incorrect information for permissions in Chapter 10, “System Procedures.” The correct permission information for each stored procedure is listed in the following table.
Procedure name |
Permissions |
---|---|
sp_iqdatatype |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqevent |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqhelp |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqjoinindex |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqpkeys |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqprocedure |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqprocparm |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqshowpsexe |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqsysmon |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqversionuse |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |
sp_iqwho |
DBA authority required. Users without DBA authority must be granted execute permission in order to run the stored procedure. |