Menu
I need to give a database user read access to the sys.master_files table. How can I do that?
Currently the user has this permissions:
Calling SELECT on sys.master_files returns an empty result. I also tested the same query with the sa user which works as expected.
443
Right-click a stored procedure and select Properties. In the Stored Procedure Properties -stored_procedure_name dialog box, under select a page, select Permissions. Use this page to add users or roles to the stored procedure and specify the permissions those users or roles have.
Right-click on Logins and select New. Enter the username. To set permissions, double-click the user account and do one of the following: If you are using SQL Authentication, enter the user name.
Navigate to Security, right-click Logins and select New Login. On the General screen, select a user or users group. On the User Mappings screen, assign all tables related to NetWrix software the db_datareader role (for example NetWrix_FS_Change_Reporter, or NetWrix_Event_Log_Manager etc).
for you to run successfully
select * from sys.master_files
the minimal permissions that you need to grant is as follows:
GRANT VIEW ANY DEFINITION TO [texas_user]
GO
I have tested and it works fine on sql 2008 r2
regards
marcelo
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
