Thread: Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username

<dterrors@hotmail.com> wrote in message
news:1191171471.166339.141990@d55g2000hsg.googlegroups.com...
>
> I don't care if it's part of the SQL standard or not. I don't care if
> oracle does it or not.  You're losing mysql converts as they go
> through the tutorial and get to this point. Or worse, they just "grant
> all" because it's easier, thus causing security holes.  User
> friendliness matters.
>

You can use the pgAdmin's grant wizard to do what you want.

Regards,

Ben

BTW thanks for the polite e-mail. :-/



On Oct 1, 7:28 am, "Ben Trewern" <ben.trew...@mowlem.com> wrote:

> You can use the pgAdmin's grant wizard to do what you want.
>

I shouldn't need a GUI tool to do something so mundane.

>
> BTW thanks for the polite e-mail. :-/

Given that it's been four years and countless requests for this, a
wakeup call style email is justified.



Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username

From
"Scott Marlowe"
Date:
On 10/1/07, MrKrinkle <yugyug66@hotmail.com> wrote:
> On Oct 1, 7:28 am, "Ben Trewern" <ben.trew...@mowlem.com> wrote:
>
> > You can use the pgAdmin's grant wizard to do what you want.
> >
>
> I shouldn't need a GUI tool to do something so mundane.

And you don't.  Very very simple plsql code to do it has been posted
dozens of times.   You don't have to be a genius to cut and paste it.

> > BTW thanks for the polite e-mail. :-/
>
> Given that it's been four years and countless requests for this, a
> wakeup call style email is justified.

Way to go!  You tell those guys who you don't pay how to do things!
Those uncaring bastards!  Now they'll listen right up and do what you
tell them!  Why, if you shout a little louder, we might have
multi-master synchronous replication this time next week!

Wait, I've got a better idea.  Get out your checkbook and write them a
check to do it.

Honestly, it's a feature I'd love to have too.  But seeing as how I
can't  implement it, and don't have a fat enough wallet to pay them to
do it, I'll just put in my vote for it like everyone else.  Minus the
F bomb.

On Mon, 2007-10-01 at 10:52 -0700, MrKrinkle wrote:
> Given that it's been four years and countless requests for this, a
> wakeup call style email is justified.
>

A "wakeup call" might be justified if:
(1) it's on -advocacy (after all, the primary threat in his email is
that we would lose users...)
(2) it's good advocacy, i.e. not rude, insulting, demanding, or vulgar

Regards,
    Jeff Davis


Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username

From
dterrors@hotmail.com
Date:
On Oct 2, 3:14 pm, pg...@j-davis.com (Jeff Davis) wrote:

> A "wakeup call" might be justified if:
> (1) it's on -advocacy (after all, the primary threat in his email is
> that we would lose users...)
> (2) it's good advocacy, i.e. not rude, insulting, demanding, or vulgar
>

Good point, I apologize for posting it in the wrong group, I didn't
notice the advocacy group.

And that's the only thing I apologize for.  It's good advocacy.



Re: It's time to support GRANT SELECT,UPDATE,...,...,... ON database.* to username

From
Michael Glaesemann
Date:
On Oct 2, 2007, at 22:58 , dterrors@hotmail.com wrote:

> And that's the only thing I apologize for.  It's good advocacy.

Just curious, but are you and MrKrinkle <yugyug66@hotmail.com> the
same individual? I just ask because your posting style is similar.


Michael Glaesemann
grzm seespotcode net