script to restrict user to a table

• sql777

  SSC Veteran

  Points: 207

  More actions

  August 13, 2003 at 4:52 pm

  #358112

  Hi,

  How can i restrict a user to a specific table only, give the user SELECT rights ONLY.

  please dont say look in BOL!

  hehe

  thanks!

• mccork

  SSC-Insane

  Points: 22288

  More actions

  August 13, 2003 at 5:08 pm

  #469826

  deny all on tablename to whoever

  grant select on tablename to whoever

  PS. Peek in BOL

  Cheers,

  - Mark

  
  Cheers,
  - Mark