Hi .. few clarifications
1) After Revoking DBADM authority from user, is it necessary to bind all plans and packages associated with that user ? In our system in SYSTABAUTH there are few entries related to packages(grantees) for which AUTHHOWGOT field is D and grantor is user having dbadm authority. In case I remove DBADM authority from GRANTOR, will that affect operations of applications even if Grantor has execute prvilege on all packages. 2) when we say SET CURRENT SQLID = 'XYZ' while exeucuting any query what is mean by this .. Understandably If user ABC is part of group XYZ and database rights are assigned to XYZ then while executing any query thru ABC user we have to give current SQL ID as XYZ. JAcky ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
