数据库访问控制在sql server 2014中执行用户定义的服务器角色 [英] Database access control trhough a user defined server role in sql server 2014
问题描述
我正在研究SQL Server 2014.有一个用户定义的服务器角色 " XX_Users"在这台服务器上。此角色以某种方式连接到特定数据库:XX_database。即使登录访问XX_database,它也无法正常工作,除非
此用户映射到 "XX_Users"服务器角色。
I am working on a SQL Server 2014. There is a user defined server role "XX_Users" on this server. This role is somehow connected to a spesific database: XX_database. Even if a login gets access to XX_database it does not work properly unless this user mapped to the "XX_Users" server role.
我不确定我是否有必要的权限来通过SSMS中的脚本选项查看代码。我找不到连接 "XX_Users"服务器角色到XX_database访问。
I am not sure whether I have necessary prividliges to see the code through scripting option in SSMS. I could not find to connect "XX_Users" server role to XX_database access.
我想在其他数据库上复制相同类型的安全性(通过定义主要控制对数据库的访问的服务器角色)。如何实现这一目标?
I want to replicate the same type of security on an other database (by defining a server role that primarily controls access to a database). How can this be achived?
谢谢。
Sedso
推荐答案
嗨sedo,
Hi sedo,
根据您的描述,我的理解是您希望通过用户定义的服务器角色来限制数据库访问。
According to your description, my understanding is that you want to limit database access through user-defined server role.
从SQL Server 2012开始,你
能够创建用户定义的服务器级角色。您可以参考以下链接使用tsql或ssms创建服务器角色:
https://www.mssqltips.com/sqlservertip/2699/sql-server-user-defined-server-roles/
From SQL Server 2012 you have the ability to create a user defined server level role. You can refer to the link below to create a server role using tsql or ssms: https://www.mssqltips.com/sqlservertip/2699/sql-server-user-defined-server-roles/
希望这可以帮到你。
祝你好运,
Dedmon Dai
Dedmon Dai
这篇关于数据库访问控制在sql server 2014中执行用户定义的服务器角色的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!