Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

SQL Server users Logins and permissions

We have production database called X and we have to give access to all developers to access this server with limited privileges.

So this we have created user called DevUser (dbo schema).

In generally, what are the privileges/rights required for Devuser for development or enhancements

Note: the reason for creating new user: before all developers are using sa login and sa password. some developer is by mistakenly dropped  some objects.
0
srinivas_ganamur
Asked:
srinivas_ganamur
2 Solutions
 
brd24gorCommented:
I would not give developers anything but public and datareader access to a production server and database, respectively.
0
 
marat-ozCommented:
1. Create windows group DevUserGroup on server or on domain, and add members of Dev team to the group.
2. Give  DevUserGroup public access to server
3. Give  DevUserGroup read-only access to database
4. Change sa password, and write down the old and new passwords, in case if some legacy applications are using sa login, you should be able change sa password back.  
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
srinivas_ganamurAuthor Commented:
Dear marat-oz/brd24gor,

Some developers has to modify objects in database (proc,table structure, views) because of new change request of clients.

But your saying ready-only access/public access, i think your suggestion is not possible right?
0
 
marat-ozCommented:
if you want to manage access per user login, in that case create db roles and assign each login to appropriate role.
You can group developers by their roles also.
It all depends on your circumstances.

0
 
srinivas_ganamurAuthor Commented:
--
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now