On Wed, Mar 07, 2001 at 03:40:44PM -0500, Roland Roberts wrote:
> > "bk" == Boulat Khakimov <[EMAIL PROTECTED]> 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
you can also do it by a shell script
grantall.sh:
## start of grantall.sh ###
#!/bin/ash
SQL="SELECT relname FROM pg_class WHERE (relkind = 'r' OR relkind = 'S')
AND relname !~ '^pg_' ORDER BY relname"
OBJ=`psql -t -c "${SQL}" $1`
# OBJ=`echo ${OBJ} | sed 's/EOF//g'`
OBJ=`echo ${OBJ} | se
Are you looking for "grant all to public" or "grant select to public"?
- Original Message -
From: "Roland Roberts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, March 07,
> "bk" == Boulat Khakimov <[EMAIL PROTECTED]> 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. Thi
On 3/6/01, 5:00:47 PM, Boulat Khakimov <[EMAIL PROTECTED]> 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
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
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
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go t
