Hi there....
I've the following problem:
2 Databases for 2 different application. From Application A should be a possibility to read from Database B. I realised this with creating an view in Database A which points on an table in Database B. That all works fine as long as the user is granted in both databases. I hoped that when I grant the User only to the view in Database A that'll do, but this raise an error that the User in DB B has no rights.
Is there a way to achieve this without granting all users in Database B on the specific table? (perhaps something like executing a view or stored procedure in another security context or something like this?)
Thanx for all comments!
I've the following problem:
2 Databases for 2 different application. From Application A should be a possibility to read from Database B. I realised this with creating an view in Database A which points on an table in Database B. That all works fine as long as the user is granted in both databases. I hoped that when I grant the User only to the view in Database A that'll do, but this raise an error that the User in DB B has no rights.
Is there a way to achieve this without granting all users in Database B on the specific table? (perhaps something like executing a view or stored procedure in another security context or something like this?)
Thanx for all comments!