SQL 2005 App role over cross DB RRS feed

  • Question

  • Hi,
    We have 2 databases say A and B. Database A is secured and has a application role. Through .Net application we execute the proc sp_setapprole and then read the data from Database A. We have an interface which has stored procedures in database B. Inside these stored procedures we have some queries selecting information from Database A. We are not able to use the sp_setapprole inside the SP as that is specific to schema. Any idea how do we achieve this?
    Monday, February 23, 2009 12:36 AM

All replies