Create a new user account for the DB2 database and assign specific privileges to it

Create a new user account for the DB2 database and assign specific privileges to it. A System Administrator account is created when the DB2 database is installed. The default account is DB2ADMIN.
At the same time, two user groups DB2ADMNS and DB2USERS will be created at www.2cto.com in the "local user and group" group of the operating system. The generated DB2ADMIN account will be
Add to the operating system account and add to these two groups. If your operating system account does not add other domains
You can log on to the account DB2ADMIN. To add a user, follow these steps: 1. Right-click my computer and click "manage" or open the "manage" menu item in the control panel,
Open the "Computer Management" console. 2. Select "local users and groups" to add a user. For example, the user name is chenjialin.
Password 123. Select "Change Password Upon next login" and select "Password Never Expires. 3. Add the user chenjialin to the user groups DB2ADMNS and DB2USERS. 4. Expand
Open all databases> EXPRESS> Users and group objects> database users, right-click and choose create. In the displayed dialog box, select chenjialin ",
Select its permissions and click OK. Or run the SQL "GRANT DBADM, CREATETAB, BINDADD, CONNECT, CREATE _
NOT_FENCED
_ ROUTINE, IMPLICIT_SCHEMA, LOAD, CREATE_EXTERNAL _
ROUTINE, QUIESCE_CONNECT, SECADM ON DATABASE
User chenjialin; "However, you must have sufficient permissions to create a USER, such as DB2ADMIN.