Skip site navigation (1) Skip section navigation (2)

Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP

From: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>
To: "'Greg Cocks'" <gcocks(at)stoller(dot)com>,"'PostgreSQL List - Novice'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP
Date: 2008-02-20 03:24:17
Message-ID: 00dd01c87370$12f003b0$9b0014ac@wbaus090 (view raw or flat)
Thread:
Lists: pgsql-novice
Probably not a PostgreSQL question - I'd imagine you'll get a better answer
on a PHP list...
 
I don't know squat about PHP on IIS, but in the web system we wrote, we
store the current user in the $_SESSION variable:
    $_SESSION["USERID"]
 
This gets set when they log in - perhaps IIS will set a similar variable
when it authenticates the user?
 

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Greg Cocks
Sent: Wednesday, 20 February 2008 13:30
To: PostgreSQL List - Novice
Subject: [NOVICE] Wondering how to get the name of the name of the user
logged on to 'my' https:// site via PHP



Hello,

 

I am a (relatively) newbie to PHP - and am wondering how to get the name of
the user logged on to 'my' https:// site via PHP.

 

IT set up the site via SSL and using active directory's users (i.e., IIS and
Windoze.) for the logon.

 

Every staff member can logon with their own Windoze network credentials,
which is pretty slick as I let the network admin take care of permissions,
passwords, etc through Windows Server.

 

Web users with limited permissions have and can be added by IT as well, with
my input on permission levels.

 

Anyway. the user has the ability to write some stuff back to a PostgreSQL
database and I would like to keep track of who is logged on that session so
I can append their username into the "change log" of the database - *but how
do I get the username?*"

 

(Note that I could potentially see myself integrating (sic) Windows User
Permissions for each user to differentiate their 'allowable' web page
functionality - but that is in the medium to far future I think.)

 

I have been exploring LDAP - but it seems like a hammer-and-walnut approach,
at least to my untrained eye.

 

Any suggestions gratefully received!

 

Cheers..

----------
Regards,
GREG COCKS
GIS Analyst V
 <blocked::mailto:gcocks(at)stoller(dot)com> gcocks(at)stoller(dot)com
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
 <blocked::http://www.stoller.com/> www.stoller.com
303-546-4300
303-443-1408 fax
303-546-4422 direct
303-828-7576 cell

 



THINK BEFORE YOU PRINT - Save paper if you don't really need to print this

*******************Confidentiality and Privilege Notice*******************

The material contained in this message is privileged and confidential to
the addressee.  If you are not the addressee indicated in this message or
responsible for delivery of the message to such person, you may not copy
or deliver this message to anyone, and you should destroy it and kindly
notify the sender by reply email.

Information in this message that does not relate to the official business
of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
Weatherbeeta, its employees, contractors or associates shall not be liable
for direct, indirect or consequential loss arising from transmission of this
message or any attachments
e-mail.

In response to

Responses

pgsql-novice by date

Next:From: sdger ergerDate: 2008-02-20 15:41:11
Subject: Why doesn't this query work? Puzzle to hard for me to crack
Previous:From: Greg CocksDate: 2008-02-20 02:30:29
Subject: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group