| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | dipti shah <shahdipti1980(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Not able to access schema functions and table... |
| Date: | 2010-02-19 08:43:43 |
| Message-ID: | 4B7E4F3F.4030004@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jignesh Shah | 2010-02-19 09:06:44 | How to get the users name from users group? |
| Previous Message | dipti shah | 2010-02-19 08:42:39 | Re: Not able to access schema functions and table... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2010-02-20 14:55:52 | Re: Function |
| Previous Message | dipti shah | 2010-02-19 08:42:39 | Re: Not able to access schema functions and table... |