Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group