grant permission on table in another database
-
Hi everyone! I need to grant permission on a table in a database to a database role in another database. I have client database containing information about clients. In another database, I have roles for different departments. Now I need to grant permission on specific tables in the client database to roles or departments which are located in another database. I have been struggling for a solution but have not succeeded. Is there any way to accomplish this task? Please help.
-
Hi everyone! I need to grant permission on a table in a database to a database role in another database. I have client database containing information about clients. In another database, I have roles for different departments. Now I need to grant permission on specific tables in the client database to roles or departments which are located in another database. I have been struggling for a solution but have not succeeded. Is there any way to accomplish this task? Please help.
Dan_K wrote:
Now I need to grant permission
:confused: Is some kind of permission problem ocurring now that wasn't occuring before? Maybe I'm missing the obvious. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]