After selecting the menu item 'Privileges' the following pulldown menu appears:
This pulldown menu comprises all functions related to the authorization of modules.
'Privileges/Show Program'
All execute and copy privileges for SQL-PL programs are displayed which one has granted to other users or has got from other users (grantees). A dialog box appears in which the result list can be restricted by specifying the owner, program, grantee, and privilege.
(Command: 'PRIVILEGES')
The additional functions Run, Revoke, and Copy are provided by push buttons.
'Privileges/Grant Program'
grants the explicit execute or copy privilege for a program to a particular user or the implicit execute or copy privilege (PUBLIC) to all SQL-PL users. No execute privileges need to be granted for successor programs that are called from this program. The copy privilege also comprises the execute privilege
(Command: 'GRANT EXECUTE', 'GRANT COPY')
'Privileges/Revoke Program'
removes the explicit execute or copy privilege for a certain program from a particular user or the implicit execute or copy privilege for a certain program from all users (PUBLIC).
(Command: 'REVOKE EXECUTE', 'REVOKE COPY')
'Privileges/Show DBPROC'
All execute privileges for DB procedures are displayed which one has granted to other users or has got from other users (grantees). A dialog box appears in which the result list can be restricted by specifying the owner, program, grantee, and privilege.
(Command: 'PPRIVILEGES')
'Privileges/Grant DBPROC'
grants the explicit execute privilege for aDB procedure to a particular user or the implicit execute privilege (PUBLIC) to all SQL-PL users. No privileges need to be granted for successor procedures that are called from this DB procedure.
(Command: 'PGRANT')
'Privileges/Revoke DBPROC'
removes the explicit execute privilege for a certain DB procedure from a particular user or the implicit execute privilege for a certain DB procedure from all users (PUBLIC).
(Command: 'PREVOKE')