User priveledges
Bob Kruger <bkruger@mindspring.com>
From: Bob Kruger <bkruger@mindspring.com>
To: pgsql-general@postgresql.org
Date: 1999-07-08T14:21:12Z
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