Re: Problem with GRANT in 7.4.19

From: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
To: "Kakoli Sen" <kakolis(at)cdacb(dot)ernet(dot)in>
Cc: pgsql-general(at)postgresql(dot)org, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
Subject: Re: Problem with GRANT in 7.4.19
Date: 2008-03-13 12:18:03
Message-ID: 758d5e7f0803130518o2c68d88cn29f4286e0fdea720@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 13, 2008 at 11:52 AM, Kakoli Sen <kakolis(at)cdacb(dot)ernet(dot)in> wrote:
> This time the command GRANT ALL PRIVILEGES ON DATABASE "casDatabase" to
> tester; did not give error.
>
> But the permission is still not there. I run the following commands :
>
> psql -d casDatabase -U tester -W. Then \z command shows empty Access
> Privileges on all tables.
>
> Also select * from table_name; gives error :
>
> ERROR: permission denied for relation table_name

You have to GRANT permissions to each and every table separately.

This is how most (all big) databases work. :-)

Regards,
Dawid

PS:
SE:LECT 'GRANT ALL ON '||schemaname||'.'||tablename||' TO tester' FROM
pg_tables; -- to get you started. :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2008-03-13 12:35:20 Re: pgfoundry is down
Previous Message Alvaro Herrera 2008-03-13 12:09:32 pgfoundry is down