HPlogo ALLBASE/SQL Database Administration Guide: HP 9000 Computer Systems > Chapter 8 System Catalog

System.Procauth

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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-23 System.Procauth

Column NameTypeLengthDescription
USERIDCHAR20Authorized DBEUserID or authorization group
NAMECHAR20Name of the procedure for which the user has EXECUTE authority
OWNERCHAR20Owner of the procedure for which the user has EXECUTE authority

 

EXAMPLE



   SELECT * FROM System.Procauth;

   --------------------+--------------------+--------------------

   USERID              |NAME                |OWNER

   --------------------+--------------------+--------------------

   JIM                 |REPORTMONITOR       |PURCHDB

   KAREN               |PROCESS12           |JOHN



   ---------------------------------------------------------------------------

   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
Feedback to webmaster