From: | Dennis Gearon <gearond(at)fireserve(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: GRANT question |
Date: | 2004-06-03 14:44:19 |
Message-ID: | 40BF3943.3030109@fireserve.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<>How about using phpPgAdmin? Or something like that?
Also, is there a SQL statement that will return all the possible
privileges? Use that in a subselect and then grant WHERE?
Chris Ochs <chris(at)paymentonline(dot)com> wrote:
<quote
---------------------------------------------------------------------->
>> Is there a shortcut to grant all privileges on a schema and it's objects to
>> a user without having to issue GRANT statements for each individual object
>> in the schema? Given all the possible types of objects I doubt it but
>> thought I would ask just in case there was a way to do it.
>
>
No. People have asked about similar ways to do lots of grants at once,
but I haven't seen anyone claim to be working on this.
</quote ----------------------------------------------------------------------->
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2004-06-03 14:47:29 | Re: Running Totals and stuff... |
Previous Message | Tom Lane | 2004-06-03 14:24:51 | Re: Page access pattern in query plan using index scan |