Blocking access to a deteminated schema

From: David Ballester <>
Date: Fri, 24 Oct 2008 18:07:26 +0200
Message-ID: <>

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


Received on Fri Oct 24 2008 - 11:07:26 CDT

Original text of this message