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

Best way to deploy to Prod Expand / Collapse
Author
Message
Posted Monday, February 3, 2014 8:55 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:52 AM
Points: 384, Visits: 2,319
I have a stored Proc "SP_TEST" which also has "GRANT EXECUTE TO USER1" . The username is different from dev to prod so whats the best way to deploy it to prod with out manual intervention ? Is it using proxy user ?

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman
Post #1537601
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse