Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2013
    Posts
    13

    Unanswered: user privilege not update after successfull command

    Hi,
    Guys pls help me for this issue.
    whenever i am trying to give dataaccess privilege to user the command was successful but when i am select the authorisation table i:e sysproc.auth_list_authorities_for_authid it not show the updated values



    r5lpar13:db2db1 67> db2 grant dataaccess on database to sapbw
    DB20000I The SQL command completed successfully.
    r5lpar13:db2db1 68>
    db2 "select authority, d_user, d_group, d_public, role_group, role_user, role_public, d_role from table (sysproc.auth_list_authorities_for_authid ('sapbw','U')) as t order by authority"r5lpar13:db2db1 68>

    AUTHORITY D_USER D_GROUP D_PUBLIC ROLE_GROUP ROLE_USER ROLE_PUBLIC D_ROLE
    -------------------------------------------------------------------------------------------------------------------------------- ------ ------- -------- ---------- --------- ----------- ------
    ACCESSCTRL N N N N N N *
    BINDADD N N N N N N *
    CONNECT N N N N N N *
    CREATETAB N N N N N N *
    CREATE_EXTERNAL_ROUTINE N N N N N N *
    CREATE_NOT_FENCED_ROUTINE N N N N N N *
    CREATE_SECURE_OBJECT N N N N N N *
    DATAACCESS N N N N N N *
    DBADM N N N N N N *
    EXPLAIN N N N N N N *
    IMPLICIT_SCHEMA N N N N N N *
    LOAD N N N N N N *
    QUIESCE_CONNECT N N N N N N *
    SECADM N N N N N N *
    SQLADM N N N N N N *
    SYSADM * N * * * * *
    SYSCTRL * N * * * * *
    SYSMAINT * Y * * * * *
    SYSMON * Y * * * * *
    WLMADM N N N N N N *



    Pls Help!

    BR
    rati

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have you tried select from SYSCAT.DBAUTH
    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

  3. #3
    Join Date
    Aug 2013
    Posts
    13
    pls tell the command of SYSCAT.DBAUTH

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    syscat tables/views are regular tables/views and can be queried with select ...
    SYSCAT.DBAUTH catalog view
    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

  5. #5
    Join Date
    Aug 2013
    Posts
    13
    thanks .....it works

Posting Permissions

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