Restrict to access tables

• DURGESH-769360

  SSC Eights!

  Points: 968

  More actions

  March 25, 2009 at 3:47 am

  #136035

  hi all,

  I want to restrict user to access tables or view through odbc

  can anybody help me to solve this issue

  regards

  Durgesh J

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  March 25, 2009 at 4:26 am

  #965873

  http://msdn.microsoft.com/en-us/library/ms811006.aspx

  go through the above link

  Tanx 😀

• BLADE-1043594

  SSCrazy

  Points: 2576

  More actions

  March 25, 2009 at 6:42 am

  #965941

  Use database snapshots

  [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

• ShekharNaidu

  SSCrazy

  Points: 2092

  More actions

  March 25, 2009 at 8:06 am

  #965995

  why can't u use GRANT/REVOKE ...???

  Shekhar..:)

  ---

  Thanks ,

  Shekhar