Whats the method to check whether a user has SECADM authority on DB2 9/
AIX. db2 get authorizations doesnt list anything related to SECADM.
Thanks,
Sam
Sam Durai - 06 Mar 2007 19:19 GMT
> Whats the method to check whether a user has SECADM authority on DB2 9/
> AIX. db2 get authorizations doesnt list anything related to SECADM.
>
> Thanks,
> Sam
Well I got the answer. It should be
db2 "SELECT GRANTEE FROM SYSCAT.DBAUTH WHERE SECURITYADMAUTH = 'Y'"