pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Queries that return permissions
4+ messages / 3 participants
[nested] [flat]

* Queries that return permissions
@ 2004-02-13 17:51  Thom Dyson <TDyson@sybex.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Thom Dyson @ 2004-02-13 17:51 UTC (permalink / raw)
  To: pgsql-php





I'm laying the ground work to migrate a database to a web front end.  One
thing I would like is, when generating the HTML,  to display read-only
fields as text, while fields that are updateable as input fields, based on
the permissions that the user has to the table.  This way a  given user
would not be confused trying to change data they have no permission to.

Does anyone know where there is code that will do this sort of thing?

Thom Dyson
Director of Information Services
Sybex, Inc.





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Queries that return permissions
@ 2004-02-13 18:15  Joe Conway <mail@joeconway.com>
  parent: Thom Dyson <TDyson@sybex.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Joe Conway @ 2004-02-13 18:15 UTC (permalink / raw)
  To: Thom Dyson <TDyson@sybex.com>; +Cc: pgsql-php

Thom Dyson wrote:
> the permissions that the user has to the table.

> Does anyone know where there is code that will do this sort of thing?

See:
http://www.postgresql.org/docs/current/static/functions-misc.html#FUNCTIONS-MISC-ACCESS-TABLE

HTH,

Joe



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Queries that return permissions
@ 2004-02-13 18:19  Thom Dyson <TDyson@sybex.com>
  parent: Joe Conway <mail@joeconway.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Thom Dyson @ 2004-02-13 18:19 UTC (permalink / raw)
  To: Joe Conway <mail@joeconway.com>; +Cc: pgsql-php





Oops,  Not running 7.4 yet.  Maybe I should upgrade :)

Thom Dyson
Director of Information Services
Sybex, Inc.



Joe Conway <mail@joeconway.com> wrote on 02/13/2004 10:15:05 AM:

> Thom Dyson wrote:
> > the permissions that the user has to the table.

> > Does anyone know where there is code that will do this sort of thing?

> See:
> http://www.postgresql.org/docs/current/static/functions-misc.
> html#FUNCTIONS-MISC-ACCESS-TABLE

> HTH,

> Joe




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Queries that return permissions
@ 2004-02-14 04:13  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: Thom Dyson <TDyson@sybex.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Christopher Kings-Lynne @ 2004-02-14 04:13 UTC (permalink / raw)
  To: Thom Dyson <TDyson@sybex.com>; +Cc: pgsql-php

Hi Thom,

Download phpPgAdmin (phppgadmin.sourceforge.net) and look at the 
getPrivileges function in classes/database/Postgres.php.

Cheers,

Chris

Thom Dyson wrote:

> 
> 
> 
> I'm laying the ground work to migrate a database to a web front end.  One
> thing I would like is, when generating the HTML,  to display read-only
> fields as text, while fields that are updateable as input fields, based on
> the permissions that the user has to the table.  This way a  given user
> would not be confused trying to change data they have no permission to.
> 
> Does anyone know where there is code that will do this sort of thing?
> 
> Thom Dyson
> Director of Information Services
> Sybex, Inc.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-02-14 04:13 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-13 17:51 Queries that return permissions Thom Dyson <TDyson@sybex.com>
2004-02-13 18:15 ` Joe Conway <mail@joeconway.com>
2004-02-13 18:19   ` Thom Dyson <TDyson@sybex.com>
2004-02-14 04:13 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox