Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP - Mailing list pgsql-novice

From Phillip Smith
Subject Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP
Date
Msg-id 00dd01c87370$12f003b0$9b0014ac@wbaus090
Whole thread Raw
In response to Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP  ("Greg Cocks" <gcocks@stoller.com>)
Responses Re: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP  ("Greg Cocks" <gcocks@stoller.com>)
List 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@postgresql.org [mailto:pgsql-novice-owner@postgresql.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
gcocks@stoller.com
S. M. Stoller Corp
105 Technology Drive, Suite 190
Broomfield, CO 80021
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 e-mail.

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

pgsql-novice by date:

Previous
From: "Greg Cocks"
Date:
Subject: Wondering how to get the name of the name of the user logged on to 'my' https:// site via PHP
Next
From: "sdger erger"
Date:
Subject: Why doesn't this query work? Puzzle to hard for me to crack