Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-12-11 : 17:50:48
|
| Hi,We have given read-only access to user1 on one of the production database1But 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 Thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-11 : 18:08:36
|
| I am not understanding your issue. Could you re-word it?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2013-12-12 : 02:09:59
|
| If you have given db_datareader rights for just one database, it is NOT possible that user can access other databases on instance. Revisit your user permissions.--------------------------http://connectsql.blogspot.com/ |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-12-12 : 13:18:07
|
quote:
Originally posted by lionofdezert
If you have given db_datareader rights for just one database, it is NOT possible that user can access other databases on instance. Revisit your user permissions.--------------------------http://connectsql.blogspot.com/
Unless that user has been granted execute rights on a stored procedure that has access to the other database - with appropriate ownership chaining or certificate signing in place. |
|
|
|
|
|
|
Intellisense