SYSADM is the highest level of administrative authority. It includes all privileges on databases within the DB2 instance as well as the authority to grant and revoke all other authorities and privileges.

DBADM provides administrative authority for a specific database. It allows the user to access and modify all objects within that database. A user with DBADM authority can grant and revoke privileges on the database but cannot grant or revoke DBADM authority.

SYSCTRL is the authority for controlling the resources used by the database manager (for example, creating and deleting databases), but it does not allow access to the data within the databases.

SYSMAINT is the authority for performing maintenance operations, such as starting and stopping the DB2 server and backing up and restoring databases. It does not allow access to the data within the databases.

LOAD authority at the database level, combined with INSERT privilege on a table, allows the user to load data into that table.

SECADM (security administrator) level applies at the database level and is the authority required to create, alter and drop security label components, security policies, and security labels, which are used to protect tables. It is also the authority required to grant and revoke security labels and exemptions as well as to grant and revoke the SETSESSIONUSER privilege. A user with the SECADM authority can transfer the ownership of objects that they do not own. The SECADM authority has no inherent privilege to access data stored in tables and has no other additional inherent privilege. It can only be granted by a user with SYSADM authority. The SECADM authority can be granted to a user but cannot be granted to a group or to PUBLIC.

Database-specific authorities are stored in the database catalogs; system authorities are stored in the database manager configuration file for the instance.

You can use the Control Center to grant and revoke database authorities.

Related concepts:

v“Database administration authority (DBADM)” in Administration Guide: Implementation

v“Extended Windows security using DB2ADMNS and DB2USERS groups” in Administration Guide: Implementation

v“LOAD authority” in Administration Guide: Implementation

v“Security administration authority (SECADM)” in Administration Guide: Implementation

v“System administration authority (SYSADM)” in Administration Guide: Implementation

v“System control authority (SYSCTRL)” in Administration Guide: Implementation

v“System maintenance authority (SYSMAINT)” in Administration Guide: Implementation

4Getting started with DB2 installation and administration

Page 11 Page 13
Page 12
Image 12
IBM VERSION 9 manual Load authority in Administration Guide Implementation
Page 11 Page 13

VERSION 9 specifications

IBM VERSION 9 is a significant advancement in IBM's product line, boasting a range of features and technologies designed to enhance performance, security, and usability in enterprise environments. This version marks a pivotal shift, focusing on integrating artificial intelligence, cloud computing, and advanced data analytics into its core functionalities.

One of the standout features of IBM VERSION 9 is its enhanced artificial intelligence capabilities. With built-in AI tools, users can leverage machine learning algorithms and natural language processing to automate tasks, gain insights from data, and improve decision-making processes. These capabilities are not only geared towards data scientists but are also accessible to business analysts who may not possess deep technical skills, thereby democratizing access to AI-driven analytics.

Another defining characteristic is the robust cloud integration. IBM VERSION 9 seamlessly supports hybrid cloud architectures, allowing organizations to operate across private and public cloud environments with ease. This flexibility enables businesses to optimize their resources, manage workloads more efficiently, and ensure data is stored and processed in the most suitable environment. Enhanced security protocols and data encryption mechanisms further ensure that sensitive information remains protected both on-premises and in the cloud.

The release also emphasizes improved performance optimizations, utilizing cutting-edge technologies such as in-memory computing and parallel processing. These enhancements result in faster data processing speeds and reduced latency, ultimately leading to improved user experiences across applications. Additionally, the system supports a variety of programming languages, allowing developers to use their preferred tools while building applications that harness the full potential of IBM VERSION 9.

User experience is another area that received attention in this version. The interface has been streamlined and made more intuitive, enabling users to navigate through features and functionalities easily. Training resources and documentation have also been improved, providing comprehensive support to ensure users can maximize the capabilities of IBM VERSION 9 without steep learning curves.

In summary, IBM VERSION 9 brings together a suite of advanced features, including enhanced AI capabilities, robust cloud integration, improved performance, and a user-friendly interface, making it a powerful tool for modern enterprises seeking to harness technology for competitive advantage. With these innovations, IBM continues to position itself as a leader in the tech industry, addressing the evolving needs of businesses worldwide.
Top Page Image Contents