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.

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:
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:
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 ]