Re: Checking Permissions with SQL - Mailing list pgsql-general

From Christopher Sawtell
Subject Re: Checking Permissions with SQL
Date
Msg-id 01021009444900.11144@berty
Whole thread Raw
In response to Checking Permissions with SQL  ("Joseph" <lters@mrtc.com>)
List pgsql-general
On Sat, 10 Feb 2001 00:17, Joseph wrote:
> How would I be able to check whether I have select,update,insert,etc
> permissions on a given table with an sql statement?
>
> I am working on a generic php interface that lists all or some tables
> and lets you edit them.
>
> I want to get away from the permisssion denied error that php gives me.

You have to GRANT whatever permissions are needed to the user the web
server run as. vis:-

grant select on school to nobody;
grant select on school_number_seq to nobody;

This enable the web server, which runs as 'nobody' to select and read from
the database.

school=# select relacl from pg_class where relname = 'school';
            relacl
-------------------------------
 {"=","chris=arwR","nobody=r"}
(1 row)


--
Sincerely etc.,

 NAME       Christopher Sawtell
 CELL PHONE 021 257 4451
 ICQ UIN    45863470
 EMAIL      csawtell @ xtra . co . nz
 CNOTES     ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

 -->> Please refrain from using HTML or WORD attachments in e-mails to me
<<--


pgsql-general by date:

Previous
From:
Date:
Subject: Strange bug in PLpgsql?
Next
From:
Date:
Subject: Resolved, maybe (Re: Strange bug in PLpgsql?)