• 1 reply
  • Latest Post - ‏2012-07-05T13:26:29Z by SystemAdmin
18 Posts

Pinned topic db2 connect to SAMPLE vs. db2start

‏2012-06-28T08:17:19Z |
Hallo everyone,

I have created a user (ratna) and granted this user these authorities:
DBADM authority
CREATETAB authority
CONNECT authority
DATAACCESS authority
ACCESSCTRL authority

If I log on as this user, and try to connect to the database SAMPLE, it works without any problems.

But if I type this command:
, then it said that I dont have the authority to start the instance. What authority does ratna need to db2start? I have tried to look at the documentation, but unfortunately I could not find the authority needed for this, I just found the authorities needed to configure the instance / start the database manager (START DATABASE MANAGER command).

Thank you for your help.

Updated on 2012-07-05T13:26:29Z at 2012-07-05T13:26:29Z by SystemAdmin
  • SystemAdmin
    5837 Posts

    Re: db2 connect to SAMPLE vs. db2start


    You need to be either SYSADM, SYSCTRL, or SYSMON to issue db2start.

    Yves-Antoine Emmanuelli