Post reply

dbo changed mid session - HOW???

  • February 28, 2007 at 7:21 am

    #115996

    HELP!

    I need to know how a .NET application could change the dbo ownership of a database in mid session.

    Yesterday, in the middle of the day, everyone using our new User Interface (from a third party vendor) was locked out of the database. Everyone logs on using the same account user name with database owner rights. When investigating the database itself, I found the dbo role was unchecked in Enterprise Manager.

    Does anyone know how this could be done short of physically unchecking the dbo role in Enterprise Manager?

    If not, I absolutely need to restrict access to the Enterprise Manager application!!!

    Window 2003 server, running SQL 2000, Terminal services, and the third party vendor application. All the patches and fix packs are in place.

  • March 2, 2007 at 2:40 pm

    #692940

    A script can do it in a snap. Look at the table, sysusers, in any database. Anyone, who has either dbo, sa, ..., can do it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply