Previous Topic: Limit Update Authority to Specific Parameters

Next Topic: Prepare to Use External Security

Limit Specific Users Update Authority

Use security rules to limit user access to resources:

You can limit update authority to specific users. The following security rule does a more specific security check when you limit the authority of your users.

Follow these steps:

  1. Turn on external security.
    EXTSECURITY=ON
    
  2. Grant the user OPSADMIN UPDATE access to external security resource OP$MVS.SQL.*.
  3. Use the following security rule to allow a specific user to access the STCTBL table:
    )SEC SQL*
    )PROC
    IF SEC.AUSQTBLS <> 'STCTBL' THEN RETURN 'NOACTION'
    IF SEC.OPAUJBNA = 'SSMADMIN' THEN
      RETURN ACCEPT
    ELSE
      RETURN REJECT
    

    External security check permits all other SQL calls.