Thread: Misapplication of Grant Wizard fails silently

The pgAdmin III grant wizard seems rather counterintuitive in its handling of
attempts to grant privileges to inappropriate objects.

If you bring up the context menu for the Schemas, then select the Privileges
tab, you can happily elect to assign privileges to groups, hit Add/Change, but
then selecting OK causes ... nothing ... to happen.

Ok, it's misguided behaviour on my part to try and do this, but I would have
figured out that I was doing something stupid a lot sooner if I'd been given an
error message, or better yet hadn't had the inappropriate tab(s) available to me
in the grant wizard (or indeed the grant wizard itself if none of these are
apt).

Are there plans to "fix" this behaviour in an imminent version, or am I missing
some obvious reason why it's needed in these contexts?

Dave.

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Minter
> Sent: 24 May 2006 13:24
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Misapplication of Grant Wizard
> fails silently
>
>
> The pgAdmin III grant wizard seems rather counterintuitive in
> its handling of
> attempts to grant privileges to inappropriate objects.
>
> If you bring up the context menu for the Schemas, then select
> the Privileges
> tab, you can happily elect to assign privileges to groups,
> hit Add/Change, but
> then selecting OK causes ... nothing ... to happen.

Do you mean you have no objects listed on the Selection tab? Or that you
do, but haven't checked any?

Regards, Dave.

Quoting Dave Page <dpage@vale-housing.co.uk>:

>
>
> > -----Original Message-----
> > From: pgadmin-support-owner@postgresql.org
> > [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Dave Minter
> > Sent: 24 May 2006 13:24
> > To: pgadmin-support@postgresql.org
> > Subject: [pgadmin-support] Misapplication of Grant Wizard
> > fails silently
> > <snip>
>
> Do you mean you have no objects listed on the Selection tab? Or that you
> do, but haven't checked any?
>
> Regards, Dave.


Ah!

Ok, I had no objects selected. So fair enough I was indeed doing something
stupid.

I do think that some sort of visible feedback that "you can't do that" would be
appropriate here (other than just not being able to I mean). Could the
appropriate bits of the privileges tab be grayed out when no objects are
selected perhaps?

Dave.

> Ah!
>
> Ok, I had no objects selected. So fair enough I was indeed doing something
> stupid.

I mean to say, rather, that I did have objects selected, but had not checked any
of them (because I'm an eejot).

Dave.