Resources › DB2DBASE Resource Class—Secure DB2 Databases

DB2DBASE Resource Class—Secure DB2 Databases

Valid on z/OS.

Use DB2DBASE to secure DB2 databases.

When used with TSS ADDTO/REMOVE, this resource class has the following format:

TSS ADDTO(acid) DB2DBASE(database,...)

Prefix length

Two to eight characters

Capacity of list

One to five DB2 database or prefixes per TSS command

This resource class has the following format for TSS PERMIT REVOKE:

TSS PERMIT(acid) DB2DBASE(database prefix(es))

Prefix length

Two to eight characters per prefix

Full name

Two to eight characters

Capacity of list

One to five databases or prefixes per TSS command

DB2DBASE is used with:

• The commands CREATE, REMOVE, ADDTO, PERMIT, REVOKE, ADMIN, DEADMIN, WHOOWNS, and WHOHAS
• The DB2DBASE ACID types User, Profile, Department, Division, Zone, DCA, VCA, ZCA, LSCA, SCA, and MSCA
• DB2DBASE(OWN) Authority

The administrator can:

• Use any of the following methods to control access to databases: Expiration, Facility, Time/Day, and Actions.
• Specify the accesses: DBADM, DBCTRL, DBMAINT, CRETAB, CRETS, DISPDB, DROP, IMAGCOPY, LOAD, RECOVDB, REORG, REPAIR, STARTDB, STATS, STOPDB, ALL, and NONE.

The DB2DBASE resource class supports all masking characters.

Examples: DB2DBASE resource class

This example gives the Finance Department (FINDEPT) ownership of the database ACCTING:

TSS ADDTO(FINDEPT) DB2DBASE(ACCTING)

This example removes ownership of the database ACCTING :

TSS REMOVE(FINDEPT) DB2DBASE(ACCTING)

This example authorizes USRJANE to create new tables on database ACCTING:

TSS PERMIT(USRJANE) DB2DBASE(ACCTING)
                    ACCESS(CRETAB)

This example revokes USRJANE's Authority to access databases ACCTING:

TSS REVOKE(USRJANE) DB2DBASE(ACCTING)