Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Unanswered: Help needed to set DB permissions

    Hi all,

    Just joined this forum. Complete noob!

    I apologise upfront already for wasting time for my noob questions.

    I am installing some applications that require DB2 and there are two things that I not sure about.

    1. Updating configuration parameters and variables, like:

    APPLHEAPSZ

    &

    CUR_COMMIT

    Is this like Windows system variables? What about the APPLHEAPSZ paramenter? (Again, I apologise, new to DB2 and not a DBA by profession)



    2. How to assign the following DB2 permissions to a specific user:

    CONNECT ON DATABASE
    CREATETAB
    USE OF TABLESPACES
    SELECT on SYSIBM.SYSVERSIONS
    SELECT on SYSCAT.DATATYPES (Object Store creation only)
    GRANT on SYSCAT.INDEXES (upgrades only)
    GRANT on SYSIBM.SYSDUMMY1
    USAGE on workload SYSDEFAULTUSERWORKLOAD
    IMPLICIT_SCHEMA on DATABASE


    Any help would be great guys!

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    look if it is db cfg setting
    applheapsz - Application heap size configuration parameter
    update db cfg like
    db2 update db cfg for dbname using applheapsz xxxx
    UPDATE DATABASE CONFIGURATION
    first check current value
    db2 get db cfg for dbname
    if automatic : adjusted by db2 system
    for grant see
    GRANT (Database Authorities)
    and also see topic in this forum : read before posting .. always indicate platform db2 edition and version...
    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 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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