This would be a cool feature...

  • I dont think this is possible, but just in case someone has heard about it. I would like a low level sql server role called 'data_slave' where the use can move data from database to database without reading the data. The idea is to define these data movement procedures then makes sure the login who operates them (DTS package or windows scheduled job) can not see the data there are moving.

    Maybe I need to look at encrypted stored procedures?

    Any ideas or creative suggestions are appreciated.

    SQL 2012 Standard VPS Windows 2012 Server Standard

  • you could use windows authentication in the dts-connection-objects, and only provide the needed rights on your prod-servers to the service accounts that runs sql-agent (so it starts the dtsrun.exe)

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply