DB2 Server-side licensing

Source: Internet
Author: User
Tags db2 db2 connect db2 connect to

Yesterday dinner came back a little late, did not write in time, today to fill up.
DB2 server-side installation will not say, many online. Let's talk about authorization today. It's a matter of trouble.
The installation will allow you to create a database. You just have to follow the prompts to create it.
First step: DB2 Connect to database user username using a password connected to the corresponding database
See if you can connect properly to the database you created.
Step two: DB2 get authorizations See how many permissions the current user has obtained
Step three: The real mandate begins.
DB2 update dbm CFG using Sysadm_group user name Grant SYSADM permissions to the user
DB2 update dbm CFG using Sysctrl_group user name Grant Sysctrl permissions to the user
DB2 update dbm CFG using Sysmaint_group user name Grant Sysmaint permissions to the user
The above will be authorized success, trouble in the following, let me go a lot of detours.

DB2 Grant SECADM on the database to user authorization Secadm permission for user name
Note: He must connect to the database using the user group. Otherwise, authorization will fail.
Column: DB2 Connect to Txhy
This does not write the user name will be automatically based on the user's user group login.

DB2 Grant SECADM on the database to user user name
Authorization Secadm Permission discovery will prompt the command to complete successfully
Other SECADM-Related authorization commands:

DB2 Connect to sample

DB2 Grant DBADM on the database to user user name

DB2 Grant Accessctrl on the database to user username DB2 grant DataAccess on the database to user username DB2 grant SQL ADM on database to user username DB2 grant WLMADM on database to user username
These are exactly what the authority will not say. Should be able to guess.
It's over. You'll find your local DB2 database connection DB2 server-side can manipulate the contents of the database table

DB2 Server-side licensing

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.