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:
PUBLIC must not have DBADM DATABASE authority or SECADM DATABASE authority.
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.
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.
(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.