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 |
|
Pseudoniem
Starting Member
1 Post |
 Posted - 2011-04-20 : 08:17:46
|
| I have a user that needs to be restricted to only viewing views. This so far is done. The only problem is the views are looking at other databases. The user then needs rights on those databases what leads to him being able to query the tables (what i dont want).How can i fix this? |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-20 : 08:24:50
|
| Maybe create views in that database and give access to those - reference those views rather than the tables.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-20 : 09:09:27
|
| Yes sure, user must have SELECT right on second database tables which are refered in your first database view.--------------------------http://connectsql.blogspot.com/ |
|
|
|
|
|
|
User rights view on other db