Resources › DB2TABLE Resource Class—Secure DB2 Tables

DB2TABLE Resource Class—Secure DB2 Tables

Valid on z/OS.

Use DB2TABLE to secure DB2 tables.

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

TSS ADDTO(acid) DB2TABLE(userid.table/view,...)

Prefix length

two to twenty‑six characters

Capacity of list

One to five DB2 tables or views or prefixes per TSS command

When used with TSS PERMIT/REVOKE, this resource class has the following format:

TSS PERMIT(acid) DB2TABLE(userid.table/view prefix(es))

Prefix length

Two to twenty‑six characters per prefix

Full name

Two to forty‑six characters

Capacity of list

One to five tables or views or prefixes per TSS command

DB2TABLE is used with:

• The commands CREATE, ADDTO, REMOVE, PERMIT, REVOKE, DELETE, ADMIN, DEADMIN, WHOOWNS, and WHOHAS
• The DB2TABLE ACID types User, Profile, Department, Division, Zone, DCA, VCA, ZCA, LSCA, SCA, and MSCA when used with TSS ADD/REMOVE
• The DB2TABLE ACID types User, Profile, DCA, VCA, ZCA, LSCA, SCA, and MSCA when used with TSS PERMIT/REVOKE
• DB2TABLE(OWN) Authority

The administrator can:

• Specify the accesses: ALL, NONE, ALTER, CREATE, DELETE, INDEX, INSERT, SELECT, and UPDATE. CREATE access only applies to Views.
• Use the following methods to control access to tables or views: Expiration, Facility, Time/Day, and Actions.

The DB2TABLE resource class supports all masking characters.

Examples: DB2TABLE Resource Class

This example gives the Payroll Department (PAYDEPT) ownership of the table USRMIKE.PAYR:

TSS ADDTO(PAYDEPT) DB2TABLE(USRMIKE.PAYR)

This example removes ownership of the table PAYR:

TSS REMOVE(PAYDEPT) DB2TABLE(USRMIKE.PAYR)

This example authorizes USRMARE to select the social security information on table USRMIKE.PAYR:

TSS PERMIT(USRMARE) DB2TABLE(USRMIKE.PAYR) ACCESS(SELECT)

This example revokes USRMARE's Authority to table USRMIKE.PAYR:

TSS REVOKE(USRMARE) DB2TABLE(USRMIKE.PAYR)

This example restricts a user's ability to update specifically‑named columns in a table. Authorize USRGAB with update privilege to correct any errors in the start‑date column on the USRMIKE.PAYR table:

TSS PERMIT(USRGAB) DB2TABLE(USRMIKE.PAYR.STRTDTE) ACCESS(UPDATE)

This example revokes USRGAB's Authority to table USRMIKE.PAYR:

TSS REVOKE(USRGAB) DB2TABLE(USRMIKE.PAYR)