June 9, 2026 at 2:14 pm
I have 13 restricted views in my EDW DB.
6 of them are created from DB1
7 of them are created from DB2.
Only 1 group should have access to view the data. Rest of the logins shouldn't. No AD group has db_datareader in any of the database. All 3 DBs reside on the same server.
Logins have been granted with grant select on all unrestricted views on all DB1, DB2 and EDW but some of the user who are not part of restricted group are still able to view in EDW. Any leads on where to look for is highly appreciated
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply