Re: Re: grant privileges to a database

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: "Dan Wilson" <phpPgAdmin(at)acucore(dot)com>, "Michael Fork" <mfork(at)toledolink(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: grant privileges to a database
Date: 2001-01-31 22:18:12
Message-ID: 01013119181206.08534@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

El Mié 31 Ene 2001 18:32, Dan Wilson escribió:
> You can do this in phpPgAdmin... it's a hack because it just pulls in all
> the objects/relations and runs a single grant statement on them, but it
> works. It puts together a query like the following:
>
> GRANT ALL ON table1, table2, table3, view1, view2, sequence1, sequence2 TO
> user
>
> Which I suppose you can do manually if you don't have phpPgAdmin installed.
>
> It ain't the prettiest, but it works!

The problem is that this is not what I'm looking for. I want the user to be
able to create new tables, views, sequences, etc on that database.

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Wilson 2001-01-31 22:39:46 Re: Re: grant privileges to a database
Previous Message Adam Haberlach 2001-01-31 21:39:18 Re: php as stored procedures

Browse pgsql-hackers by date

  From Date Subject
Next Message Dan Wilson 2001-01-31 22:39:46 Re: Re: grant privileges to a database
Previous Message Dan Wilson 2001-01-31 21:32:27 Re: Re: grant privileges to a database