Thread: 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.... -- Nothing Like the Sun
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
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
>>>>> "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
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 >
On Wed, Mar 07, 2001 at 03:40:44PM -0500, Roland Roberts wrote: > >>>>> "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 A simple two-line shell script to apply any command to a list of tables: for i in `psql mydatabase -c '\dt' -P tuples_only | cut -f2 -d ' '` do psql mydatabase -c "grant all on $i to public"; done > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl These mailing list footers really suck. Please consider removing them. They reflect poorly on the general level of the pgsql-* lists. Instead do send a one-time "welcome" message containing all your "tips" when people subscribe to a list. Probably a lost cause but the subject mangling [GENERAL], [HACKERS] etc. (especially that one! a "hacker" should know how to filter his mail) really sucks too. Educate, don't stoop. Even Outlook Express has great filtering capabilities which don't require any subject mangling. -- slashdot: I miss my free time, Rob.