Re: Are there features on other RDBMS's that it would be good for Oracle to have?
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Tue, 29 May 2012 20:26:37 +1000
Message-ID: <4FC4A45D.5060703_at_iinet.net.au>
Fergal Taheny wrote,on my timestamp of 29/05/2012 6:27 AM:
> Hi,
> Another feature I would like to see and its kind of related to what Nuno
> mentioned is the ability to grant privileges on a schema level as well as a
> object level.
>
> I've done another table driven trigger based solution for this so when any
> tables or views are created in a schema, privileges are automatically
> granted to certain roles/users.
>
> If anyone wants the code, give me a shout.
>
Date: Tue, 29 May 2012 20:26:37 +1000
Message-ID: <4FC4A45D.5060703_at_iinet.net.au>
Fergal Taheny wrote,on my timestamp of 29/05/2012 6:27 AM:
> Hi,
> Another feature I would like to see and its kind of related to what Nuno
> mentioned is the ability to grant privileges on a schema level as well as a
> object level.
>
> I've done another table driven trigger based solution for this so when any
> tables or views are created in a schema, privileges are automatically
> granted to certain roles/users.
>
> If anyone wants the code, give me a shout.
>
Oh, nifty! Good idea!
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 29 2012 - 05:26:37 CDT