cancel
Showing results for 
Search instead for 
Did you mean: 

How and where can i do a "User GRANT to SYSADM,SYSCTRL,.." ?

Former Member
0 Kudos

Hello all,

the first time we installed a new SAP-System with sapinst on DB2/LUW V9.

SAP works. (As yet we "drove" DB2 only on z/os)

SAP Created four db2 User : DB2<SID>, <SID>ADM, SAP<SID> and SAP<SID>DB!

They all have no "Grant" privilege?

How and where can i do a User grant to SYSADM,SYSCTRL,.. ,

there's no admin?

Thanks a lot!

Markus

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Markus,

in addition to explicit GRANTs DB2 LUW has the concept of privileges.

db2<dbsid> is instance owner and part of the SYSADM group db<dbsid>adm.

<sapsid>adm is part of the SYSCTRL group db<dbsid>ctl.

sap<sapsid> is part of the SYSMAINT group db<dbsid>mnt.

In addtion to that <sapsid>adm is DBADM. This right is explicitly granted during the installation with SAPInst.

The relationship between OS group and privilege is controlled by the database manager configuration parameters SYSADM, SYSCTRL and SYSMAINT.

The rights of these privileges are described in the DB2 documentation.

Regards, Jens