Hello,
I want to introduce logging to my SA application, so the users with
elevated privileges can control what "normal" users change in the
database. The log should go to the database not to a file.
I have been thinking about a logger table like:
table action:
- column: datetime_of_action
- relationship: user_who_changed_something
- relationship: affected_record
- column: custom_message
Actually I have several different tables I need to establish a
relationship with for the affected_record. I need a "mutable
relationship" column, so I can assign instances of multiple types. Is
that possible? Can you give me a hint where to read up?
Being in the design phase I am also open to other approaches on how to
tackle logging of user changes in a db.
Thanks
Sebastian
--
Sebastian Elsner - Pipeline TD - r i s e | fx
t: +49 30 201 803 00 sebast...@risefx.com
c: +49 175 336 5739 7548 www.risefx.com
r i s e | fx GmbH
Schlesische Strasse 28, Aufgang B 10997 Berlin
Richard-Byrd-Strasse 12, 50829 Cologne
Geschaeftsfuehrer: Sven Pannicke, Robert Pinnow
Handelsregister Berlin HRB 106667 B
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
