TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rene Nielsen
NA
22
31.5k
User roles when using 2 databases
Mar 8 2012 4:51 AM
Hey i have a 2008 sql server with 2 databases on
Database 1 = db1
Database 2 = db2
on DB1 i have
a user XX with public rights to enter DB1
a View called VW_TempDb1 which collects data from db2.VW_TempDb2
user xx has select rights on VW_TempDb1
on DB2 i have
a view VW_TempDb2 which collects data from Table1 joined on Table2
i need the user to collect data from VW_TempDb1 without having any rights what so ever in Db2 is this possible!!!?!?!?!?
Please help i tried looking everywhere
Reply
Answers (
0
)
How to calculate esic
Sql linking to Excel