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

Re: [SQL] Permissons on database

From: "Rob Arnold" <rob(at)cabrion(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>, "Roland Roberts" <roland(at)astrofoto(dot)org>
Subject: Re: [SQL] Permissons on database
Date: 2001-03-13 02:20:27
Message-ID: 004a01c0ab64$2e237990$4200fd0a@home (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-sql
Are you looking for "grant all to public" or "grant select to public"?


----- Original Message -----
From: "Roland Roberts" <roland(at)astrofoto(dot)org>
To: <pgsql-sql(at)postgresql(dot)org>; <pgsql-general(at)postgresql(dot)org>;
<pgsql-novice(at)postgresql(dot)org>
Sent: Wednesday, March 07, 2001 3:40 PM
Subject: Re: [SQL] Permissons on database


> >>>>> "bk" == Boulat Khakimov <boulat(at)inet-interactif(dot)com> writes:
>
>     bk> How do I grant permissions on everything in the selected
>     bk> databes?
>
>     bk> GRANT doesnt take as on object database name nor does it
>     bk> accept wild chars....
>
> Attached is some Perl code I wrote long ago to do this.  This
> particular code was done for Keystone, a problem tracking database and
> it would do a "GRANT ALL".  Modify it as needed.  Last I checked it
> worked with both PostgreSQL 6.5.x and 7.0.x
>
>


----------------------------------------------------------------------------
----


>
> roland
> --
>        PGP Key ID: 66 BC 3B CD
> Roland B. Roberts, PhD                             RL Enterprises
> roland(at)rlenter(dot)com                     76-15 113th Street, Apt 3B
> rbroberts(at)acm(dot)org                          Forest Hills, NY 11375
>


In response to

pgsql-novice by date

Next:From: Rob ArnoldDate: 2001-03-13 02:25:32
Subject: Re: Help on phrasee matching in WHERE (colum~*'.*ab*.')
Previous:From: Rob ArnoldDate: 2001-03-13 02:18:42
Subject: Re: array column problem

pgsql-general by date

Next:From: Stephan SzaboDate: 2001-03-13 02:30:55
Subject: Re: Create trigger problem :
Previous:From: Tom LaneDate: 2001-03-13 02:07:26
Subject: Re: pqReadData() - backend unexpectedly closed the channel

pgsql-sql by date

Next:From: Tom LaneDate: 2001-03-13 02:21:58
Subject: Re: Use of the LIMIT clause ?
Previous:From: Cliff CrawfordDate: 2001-03-13 02:14:21
Subject: Re: SQL Dummy Needs Help

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