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.