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