We help IT Professionals succeed at work.

DB2 grant question re:   sysibm.systabauth

Los Angeles1
Los Angeles1 asked
on
Which column name do I query the table sysibm.systabauth to discover if there is an explicit DELETE permission for a specific user

Which column do I query to see of a user has an explicit INSERT permission

Thanks
Comment
Watch Question

Data Warehouse / Database Architect
CERTIFIED EXPERT
Commented:
Hi Greensburo,

Check the columns, grantee, tcreator, and ttname.  "tcreator"."ttname" will be the schema.table name, and "grantee" will be the person that you want to check.

If there is a row with those items, a specific grant was authorized to the user.  Column "grantor" identifies who created the grant.



Good Luck,
Kent

Explore More ContentExplore courses, solutions, and other research materials related to this topic.