How to find the Privileges on an object in DB2


  I'm on DB2 UDB. I want to check the privileges on an object, whether it is a function or a procedure or a table. Is there a way i can query the database for those findings?

  Please advise.
Who is Participating?
held means you have the permission
not held means you don't have it
grantable means you can grant it to someone else
pvsbandiAuthor Commented:
Thanks! what does "Held", "Not Held" and "Held and Grantable" mean?
   Does "Grantable" mean that the privilege has been granted?
pvsbandiAuthor Commented:
Thank You!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.