Re: Are there features on other RDBMS's that it would be good for Oracle to have?
From: Fergal Taheny <ftaheny_at_gmail.com>
Date: Mon, 28 May 2012 21:27:12 +0100
Message-ID: <CAOuMUT6TQq7fAtSyGOWP6Zrs3PH6pFhcerb7HEnFgLfhqczTiA_at_mail.gmail.com>
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.
Date: Mon, 28 May 2012 21:27:12 +0100
Message-ID: <CAOuMUT6TQq7fAtSyGOWP6Zrs3PH6pFhcerb7HEnFgLfhqczTiA_at_mail.gmail.com>
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.
Fergal
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 28 2012 - 15:27:12 CDT