Who owns the tables in development environment? (upsizing from Access)

From: Randy K (wawork_at_hotmail.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 21:40:14 GMT

I've got two developers who will be upsizing an Access database but
also making modifications to the resulting tables in SQL Server 2000.
This will be our first in house application with an Access frontend.

(A little history.) Usually we alias our developers as DBO in the
database using sp_addalias. Aliasing the login of the developer as
DBO started in our Sybase shop. Being new to SQL Server we just
decided to do the same thing. Unfortunately, a login can not be a
user in any database that they are aliased as DBO. Therefore, my
developers can't do a ODBC connection to SQL 2000. I determined this
when trying to set up the ODBC connections in Windows 2000.

We don't want database tables and other objects owned by individual
logins since people change jobs and eventually leave. How do others
handle things.

Thank You!
Randy K
wawork@hotmail.com

Relevant Pages

  • Re: Whats My Password?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... the database on my computer. ... and attached to the target DBMS engine when you're ready to deploy. ... developers as it discusses issues that all architectures are likely to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Failure of Linked table in Access...
    ... SQL Server database via an ODBC DSN. ... in the Access database with various forms and reports. ... error and all subsequent queries on the PROJ table fail. ... The table is one of many tables that are linked from SQL Server ...
    (microsoft.public.access.modulesdaovba)
  • Help! Microsoft Access 2003 issue with linked tables.
    ... I have a Microsoft Access database and tables are linked to the SQL Server ... I use that SQL user in my connection string, ...
    (microsoft.public.access.security)
  • RE: Access Databases and ASP.NET 2.0
    ... but I can say that Sql Server Express is free ... and can handle much more traffic than any access database can. ... As for the default provider, its set in the base directory of IIS or in your ... I cannot set up a new website to use an Access Database to hold the site ...
    (microsoft.public.vsnet.general)
  • Re: SQL Server Role Security
    ... Columnist, SQL Server Professional ... create/alter table structures in a particular database. ... them rights to alter the database itself just rights to alter the structures ... DevAdmin is a Windows 2K Group containing the developers. ...
    (microsoft.public.sqlserver.security)