Corrections for new stored procedures permissions [CR 447961]

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.