SQL Server权限 [英] SQL Server permissions

问题描述

你好

我想知道如何限制角色或用户的权限，使其仅执行存储过程并拒绝剩余的权限.

任何帮助将不胜感激

谢谢您

Hello

I want to know how I can limit a roles'' or a users'' permissions to executing stored procedures ONLY and denying it the remaining permissions.

Any help would be highly appreciated

Thank you

推荐答案

请参阅此链接中的权限"部分:http://msdn.microsoft.com/en-us/library/aa258259%28v=sql.80%29.aspx [ ^ ]

根据上述详细信息，我想应该是创建具有定义的允许角色的新用户.

See ''Permissions'' section in this link: http://msdn.microsoft.com/en-us/library/aa258259%28v=sql.80%29.aspx[^]

Based on above details, I guess something like, creating a new user with defined allowable role should do.

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