From: | "Agustin Ignacio Genoves" <agustingenoves(at)gmail(dot)com> |
---|---|
To: | "Jessica Richard" <rjessil(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: how to create an user with ONLY select permission and nothing else? |
Date: | 2007-10-11 20:13:06 |
Message-ID: | d50beba10710111313l275f00bbtcdbeefab87cb73d9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
With this you give permission to a table
GRANT SELECT ON TABLE table TO user;
2007/10/11, Jessica Richard <rjessil(at)yahoo(dot)com>:
> I created a test user with the following command:
>
> $ createuser test
> Shall the new role be a superuser? (y/n) n
> Shall the new role be allowed to create databases? (y/n) n
> Shall the new role be allowed to create more new roles? (y/n) n
> CREATE ROLE
>
> This user at the moment does not have permission to look at any existing
> tables, but it can create a table:
>
>
> $ psql -Utest -d postgres
> Password for user test:
>
> postgres=> create table test(x int);
> CREATE TABLE
>
>
> Two questions:
>
> 1. How do I create a user with ONLY select permission but nothing else (not
> even creating any new tables)?
>
> 2. How do I check to see what permissions a particular user currently has?
>
> I know that \z tablename can show who has what permissions on a table, but
> it does not tell if a user has "create table" permission or not.
>
> Thanks,
> Jessica
>
>
>
> ________________________________
> Shape Yahoo! in your own image. Join our Network Research Panel today!
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bhella Paramjeet-PFCW67 | 2007-10-11 22:34:53 | Re: Postgres database is not logging any messages after the reboot |
Previous Message | Kevin Kempter | 2007-10-11 20:02:45 | Re: how to create an user with ONLY select permission and nothing else? |