Avatar of mossmis
mossmis
 asked on

SQL Server Database Role Losing permissions

We recently went live on a SQL server 2008 database. I have created a SQL server user and that user has been granted permissions to a database role I created. For some reason, the views I granted this role permissions to select keeps disappearing the next day. I have to keep re-adding it everyday for the my custom app to work. Anyone have any idea why they would be disappearing?

Thanks.
Microsoft SQL Server

Avatar of undefined
Last Comment
mossmis

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rich Weissler

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mossmis

ASKER
Razmus, I looked at the report. Nothing points directly to the views in question, but I have a feeling what you say might be happening. I will probably rewrite my own view outside of that database to possibly avoid this. I have a couple of different databases on the same server and they talk to each other. That is why I have the role to grant certain tables/view for a user that has limited access.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck