Perhaps "mixing" was the wrong word - I do understand what are trying to achieve- all I was trying to say is that you can use the sitemap to pass information on the currently logged-in user to the database. You do not have to store the database login and ID in the Actor field if all you want to do is track which user is making the changes - perhaps a user name/password table is one way of satisying both requirements - this has the advantage of not tying you to the specifics of authentication of that particular database. I think this is a better approach than asking the database to do it; your comparison with the timestamp field is not really a valid one as the database does not need to know anything about the "external environment" to make this kind of entry...
>>> [EMAIL PROTECTED] 2004/05/05 12:05:26 PM >>> Not really mixing things .... This is the scenario: 1) user logs in (cocoon authentication used) 2) user enters data in a form (or updates data in a form) and submits 3) data is stored in database table with this structure (example) LastName varchar(50) FirstName varchar(50) ... Actor varchar(50) TS (Timestamp) datetime The field Actor contains the login used to insert, update or (logically) delete the record. I want to prevent that I need to add the "login" as a parameter to each function (stored procedure). If I create my connection, the database can tell the login that is used. And it can fill out the timestamp for me. I do not need to pass those. Unfortunately, my connection in Cocoon is always defined with a fixed name. So even when I login with Cocoon Authentication, my database only knows one login: the one I specify in my conf. file. On 05 May 2004, at 11:42, Derek Hohls wrote: > Yves > > Are you not mixing two operations here; its the Cocoon > application that is making the DB connection - the people > who are using the that connection can be tracked and > logged separately (using various of the Cocoon authentication > methods.....). One could, of course, set up different *types* > of connections in the config file, based on, say, read-only > access vs update-type access, but this is still different from > tracking the users. > > This separation also makes your application more flexible > and easier to maintain. > > Derek > >>>> [EMAIL PROTECTED] 2004/05/05 11:37:01 AM >>> > Hi, > > I need to keep track of who changes records in my database (I use > postgres). > I would like to make a connection to my database BUT always with a > different username / password. > > In my config file, this is a fixed thing. > > Is there a way to do this ? > > > Met vriendelijke groeten, > Bien � vous, > Kind regards, > > Yves Vindevogel > Implements > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > MailScanner thanks transtec Computers for their support. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. MailScanner thanks transtec Computers for their support. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
