DTS Access Permission

• CDBA

  Hall of Fame

  Points: 3266

  More actions

  December 4, 2006 at 10:15 am

  #675536

  Pratyus,

  You can protect each DTS with different password for this purpose.

  Regards

  Utsab Chattopadhyay

  
  CDBA

• Pratyus Tripathy

  Right there with Babe

  Points: 780

  More actions

  December 4, 2006 at 10:28 am

  #675538

  Thanks Ustab,

  but i want the user can only see his authorised DTS package only.not all.

  Is there any way to give permissions for that.

  Thanks

  Pratyus

   

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  December 4, 2006 at 11:30 am

  #675552

  There is no option to hide few dts packages from one user and the few from other...

  You can hide everything or not...

  Execute permissions can be granted in a different way to execute the dts package...

  You can create a bat file and with package name as passing parameter and change the bat file to executable and give that executable to user and hide the package name from him...

  This way you can give the access to the user to execute the dts package without giving him the access...

  Note: This is also not 100% pefect solution...

   

   

  MohammedU
  Microsoft SQL Server MVP