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 |
|
ram.marella
Starting Member
15 Posts |
 Posted - 2011-05-09 : 14:46:29
|
| Hello I have here following situation.I have created a view in database1 which will select some data from Database2. I have a Role in Data base1 called Role1. I have granted select access to Role1 in database1 on created view.But, from database1 when a user logged in who has Role1 and when issues select * from that view got following error.Msg 916, Level 14, State 1, Line 1The server principal "user1" is not able to access the database "database2" under the current security context.The req here is, we have some table in database2 which data should be accessed in database1 via applciaiton (problem here is the user who loggs in via applicaiton will not have access to database2, will have access to database1 only)hence i thought of creating view in database1 which access the data from database2 and whoever is having database1 acces can see that data.anyhelp in htis regrads really appriciatedThanks, RamThanks-----------------Ram MCP |
|
|
|
|
|
View Select access issue