Re: newbie : setting access for users in a web enviroment

Hi,

thanks for the reply.

I've already read the docs.  I am using 8.0.5 btw.

One of the things I am confused is how can I give the privileges to
the database without having to know the specific tables.

The grant command when applied to a database simply mentions CREATE so
the user can create tables.  But when applied to tables, where I can
specify specific privileges I need to know the table...

If I'd need to define a user with SELECT privileges to all tables in
my test database, how could I do that?

A simple example would be fine.

On 12/23/05, Peter Eisentraut <peter_e@gmx.net> wrote:
> Am Freitag, 23. Dezember 2005 22:06 schrieb robert mena:
> > GRANT CREATE,REFERENCES ON DATABASE test TO testadm;
> >
> > \z
> > Access privileges for database "test"
> >  Schema | Name | Type | Access privileges
> > --------+------+------+-------------------
> >
> > How can I specify that the user testadm can perform those actions to this
> > database?
>
> For one thing, the command \z shows table privileges, so the empty table
> above
> is not surprising.  pg_database would give you better information.
>
> Second, the privilege type REFERENCES does not exist for databases, only for
> tables, so the command you executed does not make sense.
>
> I suggest you peruse the GRANT manual page again.
>