SYSTEM.PROCAUTH contains EXECUTE authorities for
procedures. This view, along with the
SYSTEM.COLAUTH, SYSTEM.MODAUTH, SYSTEM.SPECAUTH, and SYSTEM.TABAUTH views,
contains the security scheme for the DBEnvironment.
SYSTEM.PROCAUTH is initially empty, and it is updated whenever
ALLBASE/SQL processes a GRANT EXECUTE, REVOKE EXECUTE,
a TRANSFER OWNERSHIP of a procedure, or a DROP PROCEDURE
(without the PRESERVE option).
Table 8-24 System.Procauth
|
Column Name
|
Type
|
Length
|
Description |
|---|
|
USERID
|
CHAR
|
20
|
Authorized DBEUserID or
authorization group
|
|
NAME
|
CHAR
|
20
|
Name of the procedure for which
the user has EXECUTE authority
|
|
OWNER
|
CHAR
|
20
|
Owner of the procedure for which
the user has EXECUTE authority
|
Example |
 |
select * FROM System.Procauth;
--------------------+--------------------+--------------------
USERID |NAME |OWNER
--------------------+--------------------+--------------------
JIM@FRANCIS |REPORTMONITOR |PURCHDB
KAREN@RIZZO |PROCESS12 |JOHN@BROCK
---------------------------------------------------------------------------
Number of rows selected is 2
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
|
