星期四, 11月 11, 2010

Security in a DB2 UDB

Q1,
If the client authentication type is KERBEROS and the server authentication type is KRB_SERVER_ENCRYPT, what authentication type does the system use?

Choose an option.

CLIENT
KERBEROS < Correct >
KRB_SERVER_ENCRYPT
SERVER
SERVER_ENCRYPT



Q2,
Which privileges are object privileges?

Choose more than one option.

BIND < Correct >
BINDADD
CONNECT
PASSTHRU < Correct >
REFERENCES < Correct >


Q3,
Suppose an administrator specified the WITH GRANT OPTION option when granting a user the SELECT table object privilege. What does this enable the user to do?

Choose an option.

Grant and revoke all table object privileges except for the CONTROL privilege
Grant the SELECT privilege but not revoke any privileges < Correct >
Revoke all privileges and grant the LOAD authority
Revoke the SELECT privilege and grant any privileges specified with the WITH GRANT OPTION option



Q4,
Suppose a user needs to be able to quiesce a database, adjust parameter values in the DB2 Database Manager configuration file for an instance, and configure authority levels for other users. What is the lowest authority you can assign to the user to provide the required privileges?

Choose an option.

Database Administration authority (DBADM)
Load authority (LOAD)
System Administration authority (SYSADM) < Correct >
System Control authority (SYSCTRL)
System Maintenance authority (SYSMAINT)