Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to set up security between databases on the same instance without turning on Trustworthy? Expand / Collapse
Author
Message
Posted Wednesday, October 30, 2013 4:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 4:13 PM
Points: 102, Visits: 283
We are currently working on a Service Broker project and we need to by pass the security issue without turn on Trustworthy on the same instance.

I searched it but only found the following article without actual solution.

[url=http://social.msdn.microsoft.com/Forums/sqlserver/en-US/caab737a-eb25-4449-836b-c3152b7eb81a/service-broker-2-dbs-using-set-trustworthy-off?forum=sqlservicebroker][/url]

Can anybody who is familiar to this topic provide more detailed scripts?

Thanks a lot
Post #1509979
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse