Re: User table updates are recorded as dbo instead of userid

but now whenever anyone in the Developer group
updates a table, the update is recorded as being done by "dbo" instead of the
userid.

As you may know, the only logins mapped to the dbo user are 1) the database owner, 2) sysadmin role members and 3) dbo aliases.

I suggest you double-check sysadmin role membership. xp_logininfo will list all permission paths (including Windows groups) that provide access from the specified account and indicate if the user/group is a sysadmin:

EXEC master..xp_logininfo 'MyDomain\MyIndividualAccount', 'all'

I read about Aliases and wonder if maybe that's
what we have, but am not sure how to find out. Any help would be greatly
appreciated.

You can list dbo aliases with sp_helpuser and drop with sp_dropalias. Note that aliases were deprecated several years ago:

EXEC sp_helpuser 'dbo'
EXEC sp_dropalias 'some_login'

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"ginacresse" <ginacresse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9E3F3079-C6F6-49DD-B933-929DDFAFA946@xxxxxxxxxxxxxxxx
I am working on a vb.net app that connects to a SQL Server 2005 database.
The app uses "Trusted Connection" to connect to the db and no userid/password
is passed. I am a member of a security group called "Developers". Up until
last week, when I updated a row in a database table from the app, an Audit
table recorded the "Performed By" userid as my Windows (Active Directory)
userid. After I was unable to step into a SQL Stored Procedure last week, my
manager tried modifying permissions to allow me to debug the proc. We
finally got that to work, but now whenever anyone in the Developer group
updates a table, the update is recorded as being done by "dbo" instead of the
userid. My manager un-did whatever he did (he says, but I wonder) last week,
but we still have the problem. I have now inherited the task of getting us
back on track, but am not sure where to start. I tried changing the owner of
our test database from sa to myself, but still other members of Developers
are showing up as "dbo". I read about Aliases and wonder if maybe that's
what we have, but am not sure how to find out. Any help would be greatly
appreciated.

Thanks.

.

Relevant Pages

  • Re: CFAN (was: A small wildcard matching algorithm)
    ... Anton Ertl wrote: ... checks for updates. ... How do we know it with the Userid and Password system? ... checking of the uploaded package, and if the package looks fishy, let ...
    (comp.lang.forth)
  • Re: CFAN (was: A small wildcard matching algorithm)
    ... Anton Ertl wrote: ... checks for updates. ... How do we know it with the Userid and Password system? ... checking of the uploaded package, and if the package looks fishy, let ...
    (comp.lang.forth)
  • Re: IE/OE fix may not
    ... E.g. in order to get the desired result, by "delete the userid" ... to save the password or not (assuming AutoComplete for Passwords ... updates only when it is closed. ... I deleted using PSPV too, ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Critical XP Updates from Feb. - All fail to install
    ... I had a somewhat different experience with the same batch of updates: ... COMPLETE DISASTER!! ... I installed the new Messenger right before that; ... I typed the password in the userid box just to confirm the keys work. ...
    (microsoft.public.windowsupdate)
  • suser_sname() vs. user_name()
    ... have old record in the database that are just userid without the domain. ... that user_namereturns dbo as the username if you?re the dbo, ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)