如何授予用户访问SQL Server中的sys.master_files的权限? [英] How to give a user access to sys.master_files in SQL Server?

问题描述

我需要授予数据库用户对sys.master_files表的读取权限.我该怎么办?

I need to give a database user read access to the sys.master_files table. How can I do that?

当前用户拥有此权限:

在sys.master_files上调用SELECT返回空结果.我还用sa用户测试了相同的查询，该查询按预期工作.

Calling SELECT on sys.master_files returns an empty result. I also tested the same query with the sa user which works as expected.

推荐答案

让您成功运行

select * from sys.master_files

您需要授予的最低权限如下:

the minimal permissions that you need to grant is as follows:

GRANT VIEW ANY DEFINITION TO [texas_user]
GO

我已经测试过，并且可以在sql 2008 r2上正常工作

I have tested and it works fine on sql 2008 r2

regards
marcelo

这篇关于如何授予用户访问SQL Server中的sys.master_files的权限?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！