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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
