Controlling Privileged Users › How Do You Maintain Scope Records? › INSERT: Creating Scope Records › Syntax › Examples

Examples

This example limits a privileged user to the DB2 records in the all DB2 subsystems. The scope record name (DB2SCOP) must be placed in the user’s logonid record for this scope to be effective.

INSERT DB2SCOP INF(CDB2‑)

The next example shows how to create a scope record using another scope record. The example uses the scope record SCOPE1 and adds the entry that covers the tables that begin with SYSIBM in the TEST DB2 subsystem. Note that the ADD keyword is not needed because it is the default.

I US(SCOPE1) NEWSCOPE INF(DTBLTESTSYSIBM‑)

CA ACF2 Option for DB2 responds to the above command as follows:

INF(CDB2‑,DTBLTESTSYSIBM‑)