Hi, One wondering if the RACF experts could answer something? We are in the process of upgrading our DB2 from V8 to V13.1, which is actually working great, but they have a PC application that uses JDBC drivers to talk to DB2.
Everything works, Except a create tablespace command. So in looking at things I found, I made sure the userid being passed has access to XXXX.sysadm rule, which is all it had before, but still failed with SQL -551. Anyhow what I did to fix it was add the DBA group to that userid and everything started to work. However because that is more authority than I would like to give out, is there a way thru a RACF search or something other command I can find all the rules that has this specific GROUP specified? So maybe I can narrow down what Rule or MDSNxx or DSNADM Class that group has access to so I can narrow down that userid access to just what it needs? We are a development shop, and its developers DB2, but I still don’t like giving more access than whats actually required. Thanks. Ms Terri E Shaffer Senior Systems Engineer, z/OS Support: ACIWorldwide – Telecommuter H(412-766-2697) C(412-519-2592) terri.shaf...@aciworldwide.com ________________________________ [https://go.aciworldwide.com/rs/030-ROK-804/images/aci-footer.jpg] <http://www.aciworldwide.com> This email message and any attachments may contain confidential, proprietary or non-public information. The information is intended solely for the designated recipient(s). If an addressing or transmission error has misdirected this email, please notify the sender immediately and destroy this email. Any review, dissemination, use or reliance upon this information by unintended recipients is prohibited. Any opinions expressed in this email are those of the author personally. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN