permissions on inherited tables

permissions on inherited tables

am 21.03.2008 20:57:23 von sriram.dandapani

This is a multi-part message in MIME format.

------_=_NextPart_001_01C88B8D.AA33BDAB
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Is there a way to grant a permission on a table for a role and have that
cascade to the child tables ?

=20

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


------_=_NextPart_001_01C88B8D.AA33BDAB
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">









style=3D'font-size:10.0pt;
font-family:Arial'>Is there a way to grant a permission on a table for a =
role
and have that cascade to the child tables ?



style=3D'font-size:10.0pt;
font-family:Arial'> 



style=3D'font-size:10.0pt;
font-family:Arial'>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.









------_=_NextPart_001_01C88B8D.AA33BDAB--