Thread

1. Checking Permissions with SQL

   Joseph <lters@mrtc.com> — 2001-02-09T11:17:21Z

   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.
   
   Joseph Showalter
   
   
   

2. Re: Checking Permissions with SQL

   Christopher Sawtell <csawtell@xtra.co.nz> — 2001-02-09T20:44:49Z

   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 
   <<--