User priveledges

From: Bob Kruger <bkruger(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: User priveledges
Date: 1999-07-08 14:21:12
Message-ID: 3.0.6.32.19990708092112.007a0c60@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have what may be a fairly simple question for the group, but for the life
of me I missed it in the documentation.

In writing some perl cgi scripts for postgres, I found that I would get an
error message if a user without certain priveledges tried to do a select,
insert, delete or whatever.

What I would like to do is a quick scan prior to executing a perl script
that would look at the user and see if they have the priveledge for the
action they are about to attempt. An example would be that prior to a
screen coming up that handles deletions, a query is made to see if the user
even has this priveledge and the result is somehow captured so that they
can either go on to a subroutine generating a HTML screen for deletion or a
subroutine informing them they do not have the correct priveledge status,
etc....

Any hints?

Regards - Bob Kruger

Browse pgsql-general by date

  From Date Subject
Next Message Martin Weinberg 1999-07-08 14:44:32 Re: [GENERAL] Problems with inequalities on numeric fields in 6.5
Previous Message Oleg Broytmann 1999-07-08 09:07:12 Re: [GENERAL] Does Apache has PostgreSQL module?