How revoke SELECT permissions on a table in Data Explorer when it only lets me revoke new explicit grants I've added myself?

seberino — Fri, 09 Dec 2022 21:26:06 GMT

I'm able to make it to the Permission page of the schema and table I'm trying to do access control on within the Data Explorer page.

At first you can only grant permissions but not revoke anything. Only after you have made new grants can you revoke what you have granted.

The problem is that the default is to make new tables be readable. How can I make them

unreadable when there is no explicit SELECT permission I can delete?

Thanks,

Chris

topic How revoke SELECT permissions on a table in Data Explorer when it only lets me revoke new explicit grants I've added myself? in Data Engineering