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. |