I have a user defined data type named 'Period', and a table, also named 'Period'.The following statement, inside Period.sql, for the table, in SSDT, causes an error:GRANT SELECT ON [dbo].[Period] TO [isis_datareader] Error 193SQL71501: Permission has an unresolved reference to object [dbo].[Period].However, simply running that statement inside SQL works fine. It knows that I'm referring to the table.SSDT is confusing the two equally named values, even though SQL is perfectly okay with it.I have no intentions of renaming this type or table simply to satisfy SSDT. I can grant the appropriate permissions by using sp_exec in a PostDeployment script. It is however ugly.
Product Language
Version
Category
Operating System
Operating System Language
Steps to Reproduce
Actual Results
Expected Results
Platform
Virtualization
Please wait...