SQL Developer Environment - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Developer Environment

Author

Topic

manny.oliveros
Starting Member

4 Posts

Posted - 2007-11-06 : 00:43:18

Hi Guys,
Im new to SQL Server 2005.
In our organization, I was tasked to implement and maintain
MS SQL 2005 database.
We have several system developer and they are using MS SQL 2005
as a backend database.

Currenty, they are responsible for designing their own databases required by their application.
My concern is that I want to restrict access to my SQL server that only the DB administrator can access the
database server.

My question is that, how they can design their databases without accessing the database server. Is it
possible for them to access SQL Server with some restriction? I mean, I want to impose some security measures
that they can only access objects within their scope.

Our current scenario is that they have MS SQL Express version installed in their pc and from that terminal
they can design and test their application and after everything is in place, Its me who will migrate their
respective databases for production in MS SQL 2005 server.

Hoping you can provide me the best alterntive to this query.

Thanks a lot.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-06 : 01:02:28

Developers need access to the database in order to design and code. And yes you can restrict their access, but typically developers need db_owner in a development environment. We grant them read-only to production.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2007-11-09 : 08:16:24

What about having a staging environment , and then some sort of source control to move to a production system

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-09 : 11:33:39

That's what we call a development environment.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources