I created a custom table last week in our Test environment. It works perfectly. In working with the Test data, I decided I wanted to change from one column to two different columns. Instead of altering the table, I wanted to create a new one from scratch so I can make sure I have everything exactly as I want before I send the final code to our IT team to launch in the Live environment. I followed every step the same, except there is one additional column, and one is a different name. I keep getting an error on the new one. I have no idea where it's falling apart, but I need helping figuring out where.
This is the error I get when I try to open the new table in Test.
These are the table details of the table that works:
And these are the table details of the table that is broken:
I did execute the UP_POPULATE_REFERENCE_METADATA already.
Any thoughts on why one is working and the other isn't? What am I missing?
Thank you!
You need to grant ImpUsers the rights to the table in the database. Run something like this, assuming you want people to be able to see, add and edit/delete information on this tab. If you just want them to be able to see stuff, you should just need the "SELECT" line.
GRANT UPDATE ON [dbo].[LTR_EVENT_CONTEXT_REAL] TO [ImpUsers] AS [dbo]GRANT SELECT ON [dbo].[LTR_EVENT_CONTEXT_REAL] TO [ImpUsers] AS [dbo]GRANT INSERT ON [dbo].[LTR_EVENT_CONTEXT_REAL] TO [ImpUsers] AS [dbo]GRANT DELETE ON [dbo].[LTR_EVENT_CONTEXT_REAL] TO [ImpUsers] AS [dbo]GO
That did it! Thank you!