How to grant read permissions on catalog views in Azure SQL Data Warehouse (ADW)? RRS feed

  • Question

  • How to I grant our SQL Authentication Reporting login permissions to read catalog views?

    I tried running this to grant permission to read catalog views to our Reporting login:

        grant select on sys.pdw_table_mappings  to ReadOnlyUser

    but got this error:

     Msg 4629, Level 16, State 10, Line 18

     Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.

    When I try to run this in master, I get:

    Msg 15151, Level 16, State 1, Line 2

    Cannot find the object 'pdw_nodes_tables', because it does not exist or you do not have permission.

    Thursday, October 13, 2016 11:04 PM

All replies