List of DB2 Privileges asked in certification exams. Here are details for you.
The privileges under different groups have different meaning. Only SYSADM group has control and can access data
SYSADM Group: The SYSADM authority provides a nominated user with total control over all the resources and data controlled by the associated instance.
Admin Authority Levels
This is highest level
SYSCTRL Group: Users with membership of SYSCTRL have a broad set of powers over the instance processes and behavior, without any access to the actual data in associated databases. So a user with SYSCTRL membership can stop and start the instance, change most instance parameters, quiesce databases, change database parameters, and create and drop databases. They have no inherent access to the underlying data in the databases, however, so this role is perfect for operational control over a system.
SYSMAINT Group: A user granted membership to SYSMAINT has database-level powers over all databases associated with an instance, but no powers over the instance itself. Again useful for operational tasks such as database backups, restores, quiescence, and so forth. Members of this group also have SYSMON privileges. No data access is provided to members of this group.
SYSMON Group: The last of the instance-level special privilege groups, SYSMON membership allows users to use and control the monitoring and snapshot tools that are used for database and instance diagnostics. Members of this group have no access to data within the monitored databases.
DB2 Tough Interview Questions an e-book
DB2 is most popular database. You need a quick refresher to revise your DB2 knowledge before you attend an interview. This e-book helps you to refresh DB2 quickly.
- How to Connect DB2 in PHP engine
- DB2 Privileges to Protect Data Exclusive
- Left Vs Right Outer Join Which is Better
- Alias in SQL Query why you need it