Home Dashboard Directory Help
Search

SSDT: Confusion between UDDT and Table by Jerome Haltom - work


Status: 

Closed
 as Duplicate Help for as Duplicate


1
0
Sign in
to vote
Type: Bug
ID: 766646
Opened: 10/8/2012 3:33:33 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

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 193
SQL71501: 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.
Details
Sign in to post a comment.
Posted by Microsoft on 10/15/2012 at 12:16 PM
Hey Jerome,

Per our discussion on your forum post here - http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/ab4621f1-4bcc-4ed2-be93-fcf9d867e3ac, we have an existing work item tracking this bug, so I have Resolved this as a duplicate of that issue. Thanks again for submitting this issue and providing rapid feedback.

Thanks,
Adam Mahood
Program Manager
SSDT/DACFx
Sign in to post a workaround.