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

System.Specauth

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

SYSTEM.SPECAUTH lists all users and authorization groups and the special authorities they have been granted. Because a user must be granted the special authority CONNECT before being able to access the DBEnvironment, every user or group that has CONNECT authority to the DBEnvironment is listed.

ALLBASE/SQL updates SYSTEM.SPECAUTH when processing a GRANT or REVOKE statement specifying a special authority, or when dropping a group with special authority.

SYSTEM.SPECAUTH, along with SYSTEM.COLAUTH, SYSTEM.INSTALLAUTH, SYSTEM.MODAUTH, SYSTEM.PROCAUTH, SYSTEM.SPACEAUTH, SYSTEM.SPACEDEFAULT, and SYSTEM.TABAUTH, contains the security scheme for the DBEnvironment.

CATALOG.SPECAUTH is identical in format to SYSTEM.SPECAUTH; it permits users without DBA authority or SELECT authority on SYSTEM.SPECAUTH to examine rows to which they have access.

Table 8-34 System.Specauth

Column NameTypeLengthDescription
USERIDCHAR20Authorized DBEUserID or authorization group
DBACHAR2
  • DBA authority:

  • Y for yes

  • N for no

RESOURCECHAR2
  • Resource authority:

  • Y for yes

  • N for no

CONNECTCHAR2
  • Connect Authority:

  • Y for yes

  • N for no

MONITORCHAR2
  • Connect Authority:

  • Y for yes

  • N for no

 

EXAMPLE



   SELECT * FROM System.Specauth;

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

   USERID              |DBA|RESOURCE|CONNECT|MONITOR

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

   HPRDBSS             |N  |N       |N      |N

   TEMP                |N  |N       |N      |N

   PUBLIC              |N  |N       |N      |N

   SYSTEM              |N  |N       |N      |N

   JOHN                |Y  |N       |N      |N

   PURCHDBMAINT        |N  |Y       |N      |N

   PURCH               |N  |N       |Y      |N

   MICHELE             |Y  |N       |N      |N

   GEORGE              |N  |N       |Y      |Y

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

   Number of rows selected is 8

   U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>,or e[nd]> e
Feedback to webmaster