Visual Studio gives direct dbo access to Sql Server 2000 ???

From: BBFrost (barry.b.frost_at_remove_this.wrd.state.or.us)
Date: 07/19/05

  • Next message: BBFrost: "Re: Visual Studio gives direct dbo access to Sql Server 2000 ??? <<Update>>" 
    Date: Mon, 18 Jul 2005 15:39:28 -0700

    Greetings,

    I'm a new Sql Server administrator and I just received a shock ... We've
    set up a pretty much default instance of Win2003 server and SqlServer 2000.

    Just told the developers that I'd set up a test Sql Server instance and told
    them the name. Shortly there after I found that they were connecting from
    Visual Studio are getting automatic 'dbo' access.

    Tables and views are popping up all over the place, all owned by dbo and I'm
    having a tough time figuring out what's going on.

    I've set the Sql Server 2000 Security parameters to "Sql Security & Windows"
    and I've created individual user accounts for our test database. (The
    security options I see are "SQL Server and Windows" & "Windows Only".
    Selecting "SQL Server and Windows" doesn't seem to limit the developers from
    charging in with "Window Only" access.

    For example "smithca" has a Windows NT Domain account and Visual Studio.

    Within the test_db_server database I've created a "smithca" user account.

    With the test_db "smithca" has been granted the "public" roll.

    When "smithca" fires up Visual Studio Server Explorer, points at
    "test_db_server" and creates a "Window NT integrated security" account.
    WHAM! He's got "dbo" access to the database.

    >From what I can see any developer can log into any database (test or
    production) with full DBA permissions.

    Afraid ... very afraid !!!

    Any help with this would be greatly appreciated !!!

    Thanks in advance

    Barry
    in Oregon

  • Next message: BBFrost: "Re: Visual Studio gives direct dbo access to Sql Server 2000 ??? <<Update>>"

    Relevant Pages

    • Re: Slow booting xp home.
      ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... The microsoft fax one appears twice at every boot. ... Windows is loading will come on and then the desktop, ... Visual Studio Source Control and SourceSafe -» ... Capacity Planner General SQL Server ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... Windows is loading will come on and then the desktop, ... Visual Studio Source Control and SourceSafe -» ... Visual Studio Team System -» Visual Studio Team System - Architecture ... Capacity Planner General SQL Server ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Slow booting xp home.
      ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
      (microsoft.public.windowsxp.perform_maintain)
    • Re: Remote connection failed
      ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
      (microsoft.public.sqlserver.connect)