The security mechanism of the database is one of the keys of the database system. This article will introduce you to the three main security mechanisms in the DB2 database for your reference, and hope to enlighten you.
DB2 has three main mechanisms that allow DBAs to implement database security plans: authentication, authorization, and privilege.
Five different permission levels in DB2 are SYSADM, SYSCTRL, SYSMAINT, DBADM, and LOAD.
Log on to the machine where DB2 is installed. Run the following command:
Db2 attach to db2inst1
Here, authentication is performed implicitly. The User ID used to log on to the machine. It is assumed that the operating system has verified the user identity.
Db2 connect to sample user tst1 using mypass
Db2 connect to sample user tst1 using mypass new chgpass confirm chgpass
Change Password
Type description
SERVER performs authentication on the SERVER.
SERVER_ENCRYPT authenticates on the server. Encrypt the password on the client before sending it to the server.
For CLIENT authentication on the CLIENT machine, refer to handling untrusted clients for exceptions ).
* KERBEROS authentication is performed by Kerberos security software.
* If KRB_SERVER_ENCRYPT is set to KERBEROS, authentication is performed by Kerberos security software. Otherwise, SERVER_ENCRYPT is used.
* These settings are only valid for Windows 2000 operating systems.
To view the authentication parameters in the configuration file: