Yes it is possible. You can collect the login information when the user
logs into the website and save them as Session variables. Then you can
have each query submit the username and password in the cfquery tag.
Something like this:
<cfquery name="getStuff" datasource="#APPLICATION.dsn#"
username="#SESSION.UserName#" password='#SESSION.password#">
SQL STUFF
</cfquery>
HTH!
Sharon
At 04:03 PM 3/29/2000 +0100, Mark Jones wrote:
>I am designing a system where users log in to see data and can update add
>and delete the data. What I was wondering is whether or not it is possible
>to tell which user id has edited the database. For instance, is it possible
>for a user to access the database according to his/her user id and password
>rather than using the default user id and password given by the coldfusion
>server. Or is it possible to write directly to the logs on the database
>itself with the user name and password of the user who has done the update
>etc.
>
>Any help will be greatly appreciated,
>
>Thanks in advance,
>
>Mark Jones
>[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
