Share via

permissions to developers on prod

NeophyteSQL 241 Reputation points
2020-10-05T14:48:50.627+00:00

the org that I cam working does not have any standards established.

Please provide what access levels are developers granted on production servers.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,677 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Shashank Singh 6,251 Reputation points
    2020-10-05T15:11:14.523+00:00

    Please provide what access levels are developers granted on production servers.

    There is no defined standard in this perspective, at least I have not seen one. It depends on company to company. Ideally developers should not have access to production database. They should have their dedicated QA/UAT/Test for all type of testing. On the DEV database they can either have DB owner access or DB_datareader and DB_datawriter. Depending on what they are doing permissions can be given.

    Please go through This Stackexchange Thread to see what other people believe.

    1 person found this answer helpful.
    0 comments
  2. m 4,271 Reputation points
    2020-10-06T02:44:07.527+00:00

    Hi @NeophyteSQL ,

    the org that I cam working does not have any standards established. Please provide what access levels are developers granted on production servers.

    This is different from company to company. And there is no standard for all organizations. So, I can only provide you some similar cases here. You don't need to follow them, and I believe you can make out the suitable one for your own company.

    Similar cases: what-permissions-do-you-give-developers-in-production-databases , how-can-i-manage-sql-permissions-between-development-and-production

    More information:

    permissions-database-engine , permissions-hierarchy-database-engine

    developer-database-permissions, define-sql-server-database-permissions-for-development-team

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments
  3. m 4,271 Reputation points
    2020-10-07T01:39:39.433+00:00

    Hi @NeophyteSQL ,

    Is the reply helpful?

    BR,
    Mia

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.