需要存储过程，以使数据库从生产刷新到质量检查和暂存的权限 [英] Need Stored Procedure for Permission on DB refresh from Prod to QA and staging

问题描述

实际上，我是在寻找从生产数据库刷新QA数据库后要处理权限的脚本或SP，我需要给予与他们在qa服务器中相同的权限.
请帮助我解决此问题.

Hi,
Actually iam looking for Script or SP which will take care of permission after refreshing the QA db from production db i need to give same permission wat they have in qa server.
Please help me out in this issue.

推荐答案

请参考此链接，它可能会帮助您准备脚本或sp

授予权限 [链接2 [ ^ ]

please refer this links it might help you out to prepare your script or sp

Granting permissions[^]

link 2[^]

这篇关于需要存储过程，以使数据库从生产刷新到质量检查和暂存的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！