Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
 Posted - 2009-07-20 : 09:51:45
|
| Our ERP system only uses 1 login for access to it's database. The auditing ability of the software is terrible. I am using SQL 2000. First, how unusual is it that an Enterprise Product would only use one login for every user? Is this common practice? Second, if I want to create my own auditing on a specific table using a trigger, can I get some kind of useful information about the user? Maybe their computer name or ip address? TIA. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-07-20 : 12:02:41
|
Computer name is select host_name()But I don't remember if that is valid within a trigger, which scope it gets.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
DavidChel
Constraint Violating Yak Guru
474 Posts |
Posted - 2009-07-22 : 09:55:27
|
| Thanks Peso. Does anyone have an opinon for my first question? How unusual is it for a enterprise product to use a single login? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-22 : 10:11:25
|
| it is far too common. i see it in many enterprise ERP and Accounting packages. so no, it's not that unusual. |
|
|
|
|
|
|
Tracking Database Changes