Re: Not able to access schema functions and table... - Mailing list pgsql-general

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