Re: User dbo

From: Enric (Enric_at_discussions.microsoft.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 04:53:02 -0700

Thanks for that Keith,

But I really need is a good control from Sql Server. I'm thinking that
surely there is some table where store that 'real user'. VSS is a good idea
but the case is that we're looking for a guilty...

>From Management and then 'Process Info' I see all the processes running or
waiting and in the user column "domain\Windows logon" but that isn't
sufficient.

"Keith Kratochvil" wrote:

> If you want to know who changed objects use a source control system such as
> Visual Source Safe. Implement policies where people need to check out the
> object from VSS make the appropriate change, and then create the object
> within SQL Server.
>
> It is generally recommended that dbo owns tables and stored procedures
> within SQL Server 2000, 7, and 6.5. This makes it easier to set up security
> as necessary.
>
> --
> Keith
>
>
> "Enric" <Enric@discussions.microsoft.com> wrote in message
> news:2B2F8E6C-A1B7-49EA-8DDA-6DF576C276CF@microsoft.com...
> > hi all of us,
> >
> > I've got four users which currently are updating and modifyng tables as
> well
> > as stored procedures. Well, all of them start up query analyzer using the
> > same login and password. This means that any change in any object always
> > appear as 'dbo' as owner.
> >
> > I'd like to know how to obtain the real user.
> >
> > Thanks in advance and best regards,
> >
> >
>
>

Relevant Pages

  • Re: Tracking changes in stored procedures within Visual Source Safe
    ... Not sure if this is the group to ping at for VSS related queries. ... inhouse tool that will take the latest and run it on the SQL Server ... My application has a lot of Stored Procedures and user ... > I would really like to hear what developers have been doing out there. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Server and VSS
    ... You can do this directly from the Query Analyser. ... Guru's guide (the one on t-sql stored procedures, ... > Microsoft plan to have SQL server integrated with VSS in the next version? ...
    (microsoft.public.sqlserver.programming)
  • Re: tracking changes in stored procedure in visual source safe
    ... I have not worked with VSS although IMO proper ... code management is a must for any development project. ... > I have SQL Server 2000 with the latest service packs. ... My application has a lot of Stored Procedures and user ...
    (microsoft.public.sqlserver.server)
  • Integration of MS SQL Server with VSS 6.0
    ... I want to know about integration of SQL Server 2000 integration with VSS ... so that i can check in the stored procedures in VSS and check out the ...
    (microsoft.public.vstudio.sourcesafe)