I created a user in SQL Server 2014 and then logged in with the created user. When I was updating the Table folder it appears this message:
That is, the user I created is not allowed to view the tables.
What should I do?
Error 229 in SQL Server
2
asked by anonymous 12.11.2014 / 21:28
1 answer
1
I have no experience with SQL Server, but maybe information brought in of SOEN can help you.
According to the topic, in that order:
- You should not delete any master ## certificates
- You should not mark, or should delete, the db_denydatareader permissions role and, in case of writing problems, role > db_denydatawriter
- You may need to add the user name to role public -OR- give extended view permissions sys.extended-properties to it in System Views of the database you are trying to access.
12.11.2014 / 21:37