权限tsql [英] Permissions tsql

问题描述

您好，

我正在考虑将一些proc从dbo转移到新架构。有些用户正在改变或创建新的过程。所以在转移之后，我想让他们按照之前的做法，但是在新模式下。

有没有办法让他们在dbo下的权限可以编写脚本并在新模式上运行？

请分享您的想法

谢谢

解决方案

< BLOCKQUOTE>

不确定。按照本文中的说明完成您的操作：

如何更改SQL Server对象架构

希望有所帮助，

Hello,

I am looking at transfering some procs from dbo to a new schema. There are users who are currently altering or creating new procs. So after the transfer I want to let them do what they were doing before but under the new schema.

Is there a way that their permissions under dbo can be scripted and run on new schema?

please share your thoughts

Thanks

解决方案

Sure. Follow the instructions in this article to accomplish what you're after:
How To Change SQL Server Object Schema

Hope that helps,

这篇关于权限tsql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！