Hi all,

I need to get some questions answered in order to complete a DB2 v9.5compliance check. I'm relatively new to DB2. So, any help is greatly appreciated.

I need to figure out how I can answer the below questions:

Administrator authorities
PUBLIC must not have DBADM DATABASE authority or SECADM DATABASE authority.
Database connection
If a database contains no IBM Confidential information PUBLIC may have CONNECT DATABASE authority.
If a database contains IBM Confidential information PUBLIC may not have CONNECT DATABASE authority unless access to any confidential data is restricted from PUBLIC.
Schema creation
PUBLIC must not have IMPLICIT_SCHEMA DATABASE authority
Database Manager Configuration: AUTHENTICATION If any database contains IBM Confidential information, AUTHENTICATION must not be set to CLIENT.
SRVCON_AUTH
(does not apply to versions prior to DB2 9) If any database contains IBM Confidential information, SRVCON_AUTH must not be set to CLIENT.
PUBLIC must not have CREATEIN SCHEMA privilege.
User accounts that are members of groups with SYSADM, SYSCTRL or SYSMAINT authority
DB2UDB Only: User accounts that have DBADM or SECADM privileges
User accounts that are members of groups with DBADM or SECADM privileges
How do I check or verify the required permissions, settings and privileges as mentioned in the above questions. Pardon me if this has already been covered. I couldn't find information during my search.

Once again, I appreciate all your inputs.

Best Regards,
-Naveen.