Database

View All Threads First Prev Next

grant permission on table in another database Danzy8326-Nov-12 3:55 Danzy83 26-Nov-12 3:55  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. Re: grant permission on table in another database Chris Meech26-Nov-12 8:25 Chris Meech 26-Nov-12 8:25  Dan_K wrote: Now I need to grant permission 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]

Last Visit: 31-Dec-99 18:00     Last Update: 24-Apr-24 20:56 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.