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: "Greg Cocks" <gcocks(at)stoller(dot)com>
To: "Phillip Smith" <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>,"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 17:37:42
Message-ID: 66F6CF82BF58CE4DB4285BE816B297E846FB37@tribble.SMStoller.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks Phil... was having a bit of a brain fart... 

 

    $logged = $_SERVER["AUTH_USER"] by the way...

 

Cheers...

 

Regards,

GREG COCKS

gcocks(at)stoller(dot)com <mailto:gcocks(at)stoller(dot)com> 

 

________________________________

From: Phillip Smith [mailto:phillip(dot)smith(at)weatherbeeta(dot)com(dot)au] 
Sent: Tuesday, February 19, 2008 8:24 PM
To: Greg Cocks; 'PostgreSQL List - Novice'
Subject: RE: [NOVICE] Wondering how to get the name of the name of the
user logged on to 'my' https:// site via PHP

 

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
	gcocks(at)stoller(dot)com <blocked::mailto:gcocks(at)stoller(dot)com> 
	S. M. Stoller Corp
	105 Technology Drive, Suite 190
	Broomfield, CO 80021
	www.stoller.com <blocked::http://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 

In response to

pgsql-novice by date

Next:From: Jeff WilldenDate: 2008-02-22 04:28:13
Subject: Sequences, defaults and getting a new key
Previous:From: Frank BaxDate: 2008-02-20 16:38:42
Subject: Re: 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