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:
Quote:
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
|
Quote:
|
Database Manager Configuration: AUTHENTICATION If any database contains IBM Confidential information, AUTHENTICATION must not be set to CLIENT.
|
Quote:
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.
|
Quote:
|
PUBLIC must not have CREATEIN SCHEMA privilege.
|
Quote:
|
User accounts that are members of groups with SYSADM, SYSCTRL or SYSMAINT authority
|
Quote:
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.
dBforums
>
DB2 Health Check and Compliance Check
10-21-09, 12:30
Linear Mode
