One Comment on “Which two of the following authorities allow a user to create a new database?”

1. Chow, Kenneth KY says:

   December 25, 2017 at 8:50 pm

   Obtaining SYSADM authority
   SYSADM authority in DB2 is comparable to root authority on UNIX or Administrator authority on
   Windows. Users with SYSADM authority for a DB2 instance are able to issue any DB2 commands
   against that instance, any databases within the instance, and any objects within those databases.
   They also have the ability to access data within the databases and grant or revoke privileges and
   authorities. SYSADM users are the only users allowed to update the DBM CFG file

   Obtaining SYSCTRL authority
   Users with SYSCTRL authority can perform all administrative and maintenance commands within
   the instance. However, unlike SYSADM users, they cannot access any data within the databases
   ibm.com/developerWorks/ developerWorks®
   DB2 9 Fundamentals exam 730 prep, Part 2: Security Page 13 of 29
   unless they are granted the privileges required to do so. Examples of commands a SYSCTRL user
   can perform against any database in the instance are:
   • db2start/db2stop
   • db2 create/drop database
   • db2 create/drop tablespace
   • db2 backup/restore/rollforward database
   • db2 runstats (against any table)
   • db2 update db cfg for database dbname

   
   
   
   0

   
   
   
   0