0

I'd like to be able to create a View in one database (let's call this Database A) that is comprised of selected fields from a particular table in another database (Database B). However, I'd like this view to be accessible by a user that has read/write rights to Database A, but no rights to Database B directly. Is this possible?

Improve this question

1 Answer 1

Reset to default
0

Cross-database ownership chaining (ALTER DATABASE <dbname> SET DB_CHAINING ON) should work for this situation.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .