How to grant "Administrative Authority"

[pfist]

I am trying to get the proper authorization necessary to be able to create procedures and functions. I think that is what I need. We tried to to GRANT 'insert' on SYSPARMS and SYSPROCS tables but the grants failed. So my question is:

How does one grant "Administrative Authority" to a developer/user?!?!?!?!?!?


Per the documentation below, all my create procedure problems go away when I have this authority.

Thanks in advance, pfist

From the DB2 documentation and listed below, the authorization requirements necessary to excecute "CREATE PROCEDURE" statement:
--------------------------------------------------------------------------
Authorization

The privileges held by the authorization ID of the statement
must include at least one of the following:

For the SYSPROCS catalog view and SYSPARMS catalog table:
The INSERT privilege on the table, and
The system authority *EXECUTE on library QSYS2
Administrative authority < -- THIS IS WHAT I WANT!!!!!!!!!!!!!!!!!!

The authorization ID of the statement has the INSERT privilege
on a table when:

It is the owner of the table,
It has been granted the INSERT privilege on the table, or
It has been granted the system authorities of *OBJOPR and
*ADD on the table.

If the external program exists, the privileges held by the authorization
ID of the statement must include at least one of the following:

For the external program referenced in the SQL statement:
The system authority *EXECUTE on the external program, and
The system authority *EXECUTE on the library containing the
external program Administrative authority

 

[Crox]

Hi,

Perhaps you get your answer here:

http://mvshelp.com/cgi-bin/ubbcgi/f...B2,+SQL,+QMF&number=2&DaysPrune=10&LastLogin=

Regards,

Crox