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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  View is not accesing

Author  Topic  learntsql 524 Posts Posted - 2010-12-06 : 01:31:45 Hi All, I have 2 databases. In one database i created a view which access the one table and one view of other databse. I created separate login to access this view and gave select permissions on this user. but when i access the view its giving error as Msg 916, Level 14, State 1, Line 2 The server principal "Login" is not able to access the database "MainDatabase" under the current security context. Please help me. TIA.