Quick Beginnings

Changing Default Privileges for Users

By default, System Administrative (SYSADM) privileges are granted to the following:

OS/2: A valid DB2 user ID which belongs to the UPM Administrator or Local Administrator group.
UNIX: A valid DB2 username that belongs to the primary group of the instance owner's user ID.
Windows 95: Any Windows 95 user.
Windows NT: A valid DB2 username which belongs to Administrators group.

You can change the users who have administrator privileges for each DB2 instance by changing the SYSADM_GROUP parameter; but before you do, ensure that the group exists. To check to see if this group exists, do the following:

For Windows NT users: Use the Windows NT User Manager Administrative Tool.
For OS/2 users: Use a UPM administrator user ID to create groups and assign membership. For information on using UPM, see Chapter 40. "Administering and Using OS/2 User Profile Management on OS/2 Systems".

To use another group as the System Administrative group (SYSADM_GROUP), update the database manager configuration file.

The SYSADM_GROUP parameter is not used for the Windows 95 operating system.

To change the System Administrative group (SYSADM_GROUP) on the server instance: (For OS/2 and Windows NT workstations.)
1. Start the Control Center.
2. Click on the [+] sign beside the Systems icon to list all the systems known to your workstation.
3. Click on the [+] sign for the system that contains the instance you want to update.
4. Select the instance that you want to change the SYSADM_GROUP parameter for and click on the right mouse button.
5. Select the Configure option.
6. Select the Administration tab.
7. Select the System Administration Authority Group parameter and enter the name of an existing group that you want to assign this privilege to in the Value box.
8. Click on OK.
9. Stop and Start the database instance.
To change the System Administrative group (SYSADM_GROUP) on the client instance: (For OS/2 and Windows NT workstations.)
1. Start the Client Configuration Assistant (CCA).
2. Click on the Client Settings push button.
3. Select the Administration tab.
4. Select the parameter you want to change and enter the name of an existing group that you want to assign this privilege to in the Value box.
5. Click on OK.
6. Stop all applications that are using DB2, including the CCA. When restarted they will be using the new value for SYSADM_GROUP.
Using the command line processor:
To change the System Administrative group (SYSADM_GROUP) parameter to dbadmin on the server instance, use:
```
   update dbm cfg using SYSADM_GROUP dbadmin
   db2stop
   db2start
```
To change the System Administrative group (SYSADM_GROUP) parameter to dbadmin on the client instance, use:
```
   update dbm cfg using SYSADM_GROUP dbadmin
   terminate
```
Stop all applications that are using DB2. When restarted they will be using the new value for SYSADM_GROUP.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]