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 |
|
ohiocowboy
Starting Member
1 Post |
 Posted - 2010-06-28 : 15:15:17
|
| For the last 3 months I have used system_user to identify who made changes to a table in our SQL 2005 database. I use the user to send out alerts to the appropriate people and departments when various activities take place, order changes, new orders, receipt of product, etc. No problems until last week, Now all changes are made by the username 'sa' instead of the windows username. This started in the middle of the day and I was told we made no changes or updates to the system. Any ideas on why I can no longer see the user name?Thanks |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-06-28 : 15:42:06
|
| It sounds like someone changed the credentials on the connection string. sa is not one I would associate with an application connecting to the database(s). To many proviliges that can come back to haunt you, especially if some lousy dynamic SQL is involved in the application itself. Talk to the developers/implementers and see what has changed. To go from individual login credentials and rights to one power user, something has assuredly changed.Terry-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby |
 |
|
|
|
|
|
SQL Username (system_user)