Thanks. That worked.
On Fri, Feb 19, 2010 at 2:02 PM, Guillaume Lelarge
wrote:
> Le 19/02/2010 08:21, dipti shah a écrit :
> > Hi,
> >
> > I have executed below queries.
> >
> > CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
> >
> > GRANT ALL ON SCHEMA mydb_schema TO postgres;
> >
> > REVOKE
On 19/02/10 07:21, dipti shah wrote:
Hi,
I have executed below queries.
CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
GRANT ALL ON SCHEMA mydb_schema TO postgres;
REVOKE ALL ON SCHEMA mydb_schema FROM PUBLIC;
user1=> select * from mydb_schema.test1;
ERROR: permission denied for mydb
Le 19/02/2010 08:21, dipti shah a écrit :
> Hi,
>
> I have executed below queries.
>
> CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
>
> GRANT ALL ON SCHEMA mydb_schema TO postgres;
>
> REVOKE ALL ON SCHEMA mydb_schema FROM PUBLIC;
> REVOKE ALL ON FUNCTION mydb_schema.readtable() FROM PUB
Hi,
I have executed below queries.
CREATE SCHEMA mydb_schema AUTHORIZATION postgres;
GRANT ALL ON SCHEMA mydb_schema TO postgres;
REVOKE ALL ON SCHEMA mydb_schema FROM PUBLIC;
REVOKE ALL ON FUNCTION mydb_schema.readtable() FROM PUBLIC;
GRANT EXECUTE ON FUNCTION mydb_schema.readtable() to use