I have a hosted (shared) SQL Server database and I'd like to add a read-only login. (This login will be used to build Power BI data visualization.)
Looking into this, it's far more complex than I expected.
Ideally, the guest user would be read-only and I could just add a login for the guest account. But it appears this account does not have login permission initially.
Could someone offer the simplest way--the way that alters the database the least-- to add a login that has read-only access?
In addition, is there a way to prevent access to some tables, such as my user membership tables?