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.
    TipTip:

    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;
    

11/18/2013