Thread: permissions on inherited tables

permissions on inherited tables

From
Date:

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.