Previous Topic: RESOURCENext Topic: RESOURCEGROUP


RESOURCEAUTH

Purpose

An occurrence of this record represents the privileges that have been granted to an authorization ID on a resource.

Access

Record Elements

Element name

Picture and usage

Description of contents

AUTHID

PIC X(18)

The authorization ID of the user or group to whom the privileges have been granted.

RESOURCETYPE

PIC X(4)

The resource type keyword.

Using IDMSSECS subschema:

'AREA' 'DMCL'

'DB' 'NSCH'

'DBTB' 'SPRF'

'DCA' 'SYST'

Using IDMSSECU subschema:

'GROU' 'UPRF'

'SYSA' 'USER'

RESOURCENAME

PIC X(60)

The resource name.

RUNTIMEAUTH

PIC S9(4) USAGE COMP SYNC

(Not applicable—initialized to binary zeros. EXECUTE privileges on categories and activities are stored in the RESGROUPAUTH record.)

RUNTIMEAUTHW

PIC S9(4) USAGE COMP SYNC

(Not applicable—initialized to binary zeros.)

DEFNAUTH

PIC S9(4) USAGE COMP SYNC

Definition privileges that have been granted on the resource:

  • 1—CREATE
  • 2—ALTER
  • 4—DROP
  • 8—DISPLAY
  • 16—USE
  • nn—(The sum of two or more of the above, representing multiple privileges)
  • 31—DEFINE (all definition privileges)

Note: DEFINE privilege always includes USE; however, USE is meaningful only for AREA, DB, DBTB, DMCL, and NSCH.

DEFNAUTHW

PIC S9(4) USAGE COMP SYNC

Definition privileges a user represented by AUTHID may grant to other authorization IDs.

OTHERAUTH

PIC S9(4) USAGE COMP SYNC

Special privileges:

  • 1—SYSADMIN

(Resource type SYSA only)

  • 4—DBADMIN

(Resource type DB only)

  • 8—DCADMIN

(Resource type DCA only)

  • 16—SIGNON

(Resource type SYST only)

  • 32—DBAREAD

(Resource type AREA only)

  • 64—DBAWRITE

(Resource type AREA only)

  • 96—DBAREAD and DBAWRITE

CTIME

PIC X(64) USAGE BIT

Time created.

UTIME

PIC X(64) USAGE BIT

Time of the last update.

CUSER

PIC X(18)

ID of the user who created the resource authorization.

UUSER

PIC X(18)

ID of the user who last updated the resource authorization.

FILLER

PIC X(16)

(Reserved—initialized to spaces.)