From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
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:32:51 |
Message-ID: | 4B7E4CB3.9090008@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
Le 19/02/2010 08:21, dipti shah a écrit :
> 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;
> REVOKE ALL ON FUNCTION mydb_schema.readtable() FROM PUBLIC;
>
> GRANT EXECUTE ON FUNCTION mydb_schema.readtable() to user1;
>
> GRANT SELECT ON mydb_schema.test1 TO user1;
>
> $ psql -h postgresqlhost.aus -d mydb -U user1
> psql (8.4.1)
> Type "help" for help.
> user1=> select mydb_schema.readtable();
> ERROR: permission denied for schema mydb_schema
> user1=> select * from mydb_schema.test1;
> ERROR: permission denied for mydb_schema
> LINE 1: select * from mydb_schema.test1;
> ^
> user1=>
>
> Could anyone please tell me what is wrong here? *I want users to have only
> select persions on tables of mydb_schema schema and function readtable
> execute permissions for only few users(like above user1).*
>
You should at least GRANT USAGE on your schema mydb_schema to your users.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2010-02-19 08:42:06 | Re: Getting number of affected row after performing update |
Previous Message | Adrian von Bidder | 2010-02-19 08:04:54 | set line number / input file name in psql |
From | Date | Subject | |
---|---|---|---|
Next Message | dipti shah | 2010-02-19 08:42:39 | Re: Not able to access schema functions and table... |
Previous Message | dipti shah | 2010-02-19 07:21:47 | Not able to access schema functions and table... |