Db2 On Premise and Cloud

Expand all | Collapse all

How to find out who has Update privillege

  • 1.  How to find out who has Update privillege

    Posted Tue January 08, 2019 11:31 AM
    This question was posted by Gab via Db2 Community Facebook message:
    I'd like to ask what command should be input in the terminal to displays the users who have UPDATE privilege on the table STAFF?


    ------------------------------
    Lynn Chou on behalf of Gab
    ------------------------------


  • 2.  RE: How to find out who has Update privillege

    Posted Wed January 09, 2019 01:10 PM
    Gab, just found this for you.
    https://www.ibm.com/support/knowledgecenter/bg/SSEPGG_11.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0021978.html

    You can Db2 online documentation at https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.welcome.doc/doc/welcome.html

    In addition, you can access a number of key Db2 resources here: https://community.ibm.com/community/user/hybriddatamanagement/blogs/lynn-chou/2018/08/22/key-resources-for-db2

    ------------------------------
    Lynn Chou
    ------------------------------



  • 3.  RE: How to find out who has Update privillege

    Posted Wed January 09, 2019 01:11 PM
    You may get info from SYSIBMADM.PRIVILEGES administrative view, e.g.

    SELECT AUTHID, PRIVILEGE, OBJECTNAME, OBJECTSCHEMA, OBJECTTYPE FROM SYSIBMADM.PRIVILEGES WHERE OBJECTNAME='STAFF' AND PRIVILEGE='UPDATE'

    ------------------------------
    Weiren Ding
    ------------------------------



  • 4.  RE: How to find out who has Update privillege

    Posted Wed January 09, 2019 02:08 PM
    Thank you, Weiren!


    ------------------------------
    Lynn Chou
    ------------------------------