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 |
|
beamer112
Starting Member
1 Post |
 Posted - 2012-05-18 : 11:24:17
|
| Hi,I have an application where I want the user to be able to execute queries under an application role context that has the least privileged access. This seems to work fine in general but I noticed that under this context that the user still has access to the master and tempdb and I would not want that. Is there anyone that could give an idea on how to lock this down also? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-18 : 12:11:54
|
| As long as the application role doesn't have elevated privileges in master there's nothing to worry about. You definitely don't want to block them from tempdb (if you even can), there are many features of SQL Server that use it, and queries could fail if it's blocked. |
 |
|
|
|
|
|
Application roles