We have given read-only access to user1 on one of the production database1
But today we found out from our third party monitoring tool that user’s adhoc query which is executing from SQL Management studio is blocked by some other process. And surprisingly user1 query is running on our main production database (this database is different than database1)
Just wondering what will be the root cause? user1 has read-only access to database1 only.
Is this SQL Intellisense issue? Any idea? SQL Version is 2008 + SP3