Is there a way to grant a permission on a table for a role and have that cascade to the child tables ?
I have several high volume “daily” partitioned tables that get dropped every week and every time I need to re-grant permission on the new tables created.