Top DB2 privileges really useful for certification seekers

The privilege in DB2 useful to know how DB2 protecting your data. This question asked many times in certification exams.

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.

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.

Second level

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.

Third level

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.

Fourth level

DB2 tough interview questions e-book

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.

$1.00


Also read

References

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.