granting all to user

From: Jodi Kanter <jkanter(at)virginia(dot)edu>
To: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: granting all to user
Date: 2002-01-07 21:01:43
Message-ID: 004101c197be$83083c60$de138f80@virginia.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can I grant a user all privileges to all the tables without having to type a
grant command for each table individually?

I know that I can use:
grant all on object to username

but I would like to set this person up as a superuser for now so that he can
assist with development.

It appears that when I set up users the default is NOT to give them access
to any of the tables. I would like to have the default set so that users can
read all the tables and then have the option to give this one particular
person full access.

Any suggestions???
thanks
Jodi

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-01-07 21:22:07 Re: granting all to user
Previous Message Gyozo Papp 2002-01-07 17:50:33 REQUEST: database security issues in PHP manual