Skip site navigation (1) Skip section navigation (2)

Re: Not able to access schema functions and table...

From: dipti shah <shahdipti1980(at)gmail(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
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:42:39
Message-ID: d5b05a951002190042r601ca7fax4491b5681ef77190@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novice
Thanks. That worked.

On Fri, Feb 19, 2010 at 2:02 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:

> 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
>

In response to

pgsql-novice by date

Next:From: Richard HuxtonDate: 2010-02-19 08:43:43
Subject: Re: Not able to access schema functions and table...
Previous:From: Guillaume LelargeDate: 2010-02-19 08:32:51
Subject: Re: Not able to access schema functions and table...

pgsql-general by date

Next:From: Richard HuxtonDate: 2010-02-19 08:43:43
Subject: Re: Not able to access schema functions and table...
Previous:From: Richard HuxtonDate: 2010-02-19 08:42:06
Subject: Re: Getting number of affected row after performing update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group