Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010

    Unanswered: db2 user authorization

    i want to grant new database user with authorization..

    i want to give new user with authorization to create new database, create table, insert data, etc.. except only drop/delete

    what i know, if i want to grant user to connect or so on to a database,
    first i have to connect to the database and grant authorization to the user from there..
    how about the database that not yet have been created.. that will be created in future... how can i grant the user authorization

    sorry for bad english..
    any help will be grateful..

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    for create db sysctrl/sysadmin is needed
    with this authority you also get other authority
    see infocenter for details about this
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts