您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

受限视图访问策略Restricted view access policy

RestrictedViewAccess是可为数据库的表启用的可选策略。RestrictedViewAccess is an optional policy that can be enabled for tables of a database.

为表启用此策略时,只有在数据库中具有UnrestrictedViewer角色的主体才能查询表中的数据。When this policy is enabled for a table, data in the table can only be queried by principals who have an UnrestrictedViewer role in the database. 未向UnrestrictedViewer数据库级角色注册的任何主体将无法查询表中的数据。Any principal, who isn't registered with an UnrestrictedViewer database-level role, won't be able to query data in the table. 即使是未注册的表/数据库/群集管理。Even an unregistered table/database/cluster admin.

UnrestrictedViewer角色授予对数据库中启用了策略的所有表的 view 权限。The UnrestrictedViewer role grants view permission to all tables in the database that have the policy enabled. 当前主体(数据库管理员/用户/查看器)已获得查询数据库的授权。The current principal, a database admin/user/viewer, is already authorized to query the database. 添加或删除主体可以通过DatabaseAdmin来完成。Adding or removing principals can be done by a DatabaseAdmin.

备注

无法在启用了行级别安全性策略的表上配置 RestrictedViewAccess 策略。RestrictedViewAccess policy can't be configured on a table on which a Row Level Security policy is enabled.

有关详细信息,请参阅用于管理RestrictedViewAccess 策略的控制命令。For more information, see the control commands for managing the RestrictedViewAccess policy.