How can i generate an audit report that lists all Data object privileges in my catalog

sajith_appukutt — Wed, 09 Jun 2021 06:49:34 GMT

Re: How can i generate an audit report that lists all Data object privileges in my catalog

sajith_appukutt — Mon, 21 Jun 2021 22:14:46 GMT

You could leverage SHOW GRANT which displays the privileges

SHOW GRANT [<user>] ON [CATALOG | DATABASE <database-name> | TABLE <table-name> | VIEW <view-name> | FUNCTION <function-name> | ANONYMOUS FUNCTION | ANY FILE]

You could use this code snippet to schedule a daily job that writes out this data to delta which would serve as historical audit report.

topic Re: How can i generate an audit report that lists all Data object privileges in my catalog in Data Engineering

How can i generate an audit report that lists all Data object privileges in my catalog

Re: How can i generate an audit report that lists all Data object privileges in my catalog