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_schema
Could anyone please tell me what is wrong here?
There is a USAGE permission for the schema that you need to GRANT. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
