Creating nonadministrative users in DB2 on z/OS

You should not use the administrative ArcSDE user account (sde) for the purpose of developing and utilizing ArcGIS applications or creating data. You should create stand-alone user accounts on the target DB2 machine for these purposes.

The following is an example of creating a nonadministrative ArcSDE user, EDITOR, who will be able to create and alter tables in the geodatabase:

Steps:

1. Create a stand-alone user account, EDITOR, on z/OS using RACF.
2. Add the user, EDITOR, to the ArcGIS users group using RACF.
   Tip:

   In the example given in Creating an sde user on IBM z/OS, the ArcGIS user group was named sdeusers.

3. Grant the following privileges to the EDITOR user:

   GRANT BINDADD TO EDITOR;
   GRANT CREATE ON COLLECTION SDE1 TO EDITOR;
   GRANT CREATETAB ON DATABASE SDEDBU00 TO EDITOR;
   GRANT CREATETS ON DATABASE SDEDBU00 TO EDITOR;
   

4. If you use the storage group, you need to grant the following additional privilege:

   GRANT USE OF STOGROUP ARCSDE to EDITOR;