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
Import Notes
Reply to msg id not found: MessagefromBoulatKhakimovboulat@inet-interactif.comofTue06Mar2001120047EST.3AA517BE.31EEE461@inet-interactif.com | Resolved by subject fallback
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
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
----------------------------------------------------------------------------
----
Show quoted text
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?
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.