“公共" SQL Server中的角色访问 [英] "public" role access in SQL Server

问题描述

有人能让我知道公众对sql服务器具有什么权限.

Can anybody let me know that what permission does public have in sql server.

谢谢

推荐答案

默认情况下，公共角色无法执行任何操作*.如果某些DBA希望每个人都拥有这些权限，他们将授予公共角色其他权限(查看或更改数据或运行存储的proc).

By default the public role can't do anything*. Some DBAs will grant the public role additional rights (to see or change data or run stored procs) if they want everyone to have those rights.

*-好吧，几乎所有东西.他们可以查看某些系统视图并运行不涉及任何数据的查询(例如选择'a'").

* -- Well, almost anything. They can look at some system views and run queries that don't touch any data (like "select 'a'").

要查看特定权限，请右键单击角色(在SQL 2005中为数据库">"{您的数据库}">安全性">角色">数据库角色")，然后选择属性".

To see the specific rights, right click on the role (In SQL 2005 it's Databases > {Your Database} > Security > Roles > Database Role) and select Properties.

您可能还想签出服务器级别的公共角色.在安全性">服务器角色">公共"中

You might also want to check out the server-level public role. Which is at Security > Server Roles > public

这篇关于“公共" SQL Server中的角色访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！