pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedQueries that return permissions
4+ messages / 3 participants
[nested] [flat]
* Queries that return permissions
@ 2004-02-13 17:51 Thom Dyson <TDyson@sybex.com>
2004-02-13 18:15 ` Re: Queries that return permissions Joe Conway <mail@joeconway.com>
2004-02-14 04:13 ` Re: Queries that return permissions Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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 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 ` Re: Queries that return permissions 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 17:51 Queries that return permissions Thom Dyson <TDyson@sybex.com>
2004-02-13 18:15 ` Re: Queries that return permissions Joe Conway <mail@joeconway.com>
@ 2004-02-13 18:19 ` Thom Dyson <TDyson@sybex.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-13 17:51 Queries that return permissions Thom Dyson <TDyson@sybex.com>
@ 2004-02-14 04:13 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
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