Postgres Pro
Downloads
Home   >   mailing lists

Thread: Permissons on database

Permissons on database

From
Boulat Khakimov
Date:
Hi,

How do I grant permissions on everything in the selected databes?

GRANT doesnt take as on object database name nor does it accept wild
chars....

--
Nothing Like the Sun

Re: [SQL] Permissons on database

From
"Oliver Elphick"
Date:
Boulat Khakimov wrote:
  >Hi,
  >
  >How do I grant permissions on everything in the selected databes?
  >
  >GRANT doesnt take as on object database name nor does it accept wild
  >chars....

However you can give it a list of tables (and other objects).

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "The LORD is my light and my salvation; whom shall I
      fear? the LORD is the strength of my life; of whom
      shall I be afraid?"           Psalms 27:1

Re: [SQL] Permissons on database

From
dev@archonet.com
Date:
On 3/6/01, 5:00:47 PM, Boulat Khakimov <boulat@inet-interactif.com> wrote
regarding [SQL] Permissons on database:

> Hi,

> How do I grant permissions on everything in the selected databes?

> GRANT doesnt take as on object database name nor does it accept wild
> chars....

By hand at the moment I'm afraid. There is no GRANT ALL ON ALL...

Having said that, if you have plpgsql enabled on that database you could
write a simple loop to do so for you. If you'd find one useful let me
know and I'll knock one up.

 - Richard Huxton

Re: [SQL] Permissons on database

From
Roland Roberts
Date:
>>>>> "bk" == Boulat Khakimov <boulat@inet-interactif.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@rlenter.com                     76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375
Attachment

Re: [SQL] Permissons on database

From
"Rob Arnold"
Date:
Are you looking for "grant all to public" or "grant select to public"?


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


> >>>>> "bk" == Boulat Khakimov <boulat@inet-interactif.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@rlenter.com                     76-15 113th Street, Apt 3B
> rbroberts@acm.org                          Forest Hills, NY 11375
>