When we try to login with a user who does not have dbo-rights,we will get the following error
Error : Microsoft Dynamics NAV
---------------------------
The following SQL error was unexpected.
The SELECT permission was denied on the object 'User Property', database 'Cronus TEST', schema 'dbo'.
---------------------------
OK
---------------------------
Solution :
Error : Microsoft Dynamics NAV
---------------------------
The following SQL error was unexpected.
The SELECT permission was denied on the object 'User Property', database 'Cronus TEST', schema 'dbo'.
---------------------------
OK
---------------------------
Solution :
We can resolve the issue to run the following though sql management studio (replace tblYourTableName with your table name)
grant select on dbo.tblYourTableName to public
To avoid typos, the correct script should include the square brackets:
ReplyDeleteUSE [YOUR_DATABASE_NAME]
GRANT SELECT ON [dbo].[tblYourTableName] TO PUBLIC