Re: Are there features on other RDBMS's that it would be good for Oracle to have?
Date: Mon, 28 May 2012 20:36:18 +1000
Message-ID: <4FC35522.6030908_at_iinet.net.au>
Nuno Souto wrote,on my timestamp of 28/05/2012 12:14 AM:
> Proxy logins don't let me do that: the target automatically assumes any roles
> assigned to the target login. Which in most cases is the schema owner. Not
> exactly what I wanted: I don't want everyone able to drop a table!
Apologies, forgot to add: in 11.2.0.3 I don't have this problem, just
re-confirmed. Only in 10g. Dunno why, "feature"? But the synonym management
issue is still there, of course. Which is bypassed in my case with the login
trigger.
Still would like to have everything controlled by context. I can do that easily
with MSSQL: assign a default schema to any login, with access rights specified
by schema.
That means I can have the same app's objects defined multiple times in a single instance, within a dedicated "schema" for each. For example: one for Australia, one for NZ, one for Europe, one for SAmerica, one for NAmerica. Same table names, different owners, different sets of logins for each, no synonyms anywhere. Dirt easy to do with MSSQL - a royal pain with Oracle necessitating the use of a login trigger and a control table - or multiple instances... And yet so easy to resolve with the simple concept of assigning current_schema via context - one for each continent - and then giving each login one of those contexts.
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Mon May 28 2012 - 05:36:18 CDT