I am not a Microsoft SQL expert, but I need to solve this trouble.
I must configure a MS SQL access as read only user.
I understood that I must set "db_datareader* permission for this new read only user (guide: https://www.itsupportguides.com/knowledge-base/server-side-tips/sql-management-studio-how-to-create-read-only-users/)
After that I would limit read only user database view.
I would that this limited user can only see specific tables inside specific database (databases).
Is it possible?
How can I do it?