Blocking access to a deteminated schema
From: David Ballester <ballester.david_at_gmail.com>
Date: Fri, 24 Oct 2008 18:07:26 +0200
Message-ID: <6a29f8b0810240907h5c10fa0mf860148545415f1c@mail.gmail.com>
Date: Fri, 24 Oct 2008 18:07:26 +0200
Message-ID: <6a29f8b0810240907h5c10fa0mf860148545415f1c@mail.gmail.com>
Hi people:
I'm trying to block the access to all objects of one schema. I can alter it and block the connect but any other schema in the same database with grants, will be able to access the objects that I'm trying to block. I know than I can go to several role/privs views and extract data to konw who has grants to what object but i wanna know if exists a 'simple' command to block access on schema objects even in the case that you have grants to
Thanks and regards
D.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 24 2008 - 11:07:26 CDT