Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2007 at 07:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.