How to give the permission to user access Single Table In aDatabase

• Arjun SreeVastsva

  SSCertifiable

  Points: 7141

  More actions

  June 7, 2011 at 5:08 am

  #238724

  Hi,

  Can i know the how to give permission to user access the single table in a database .?

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  June 7, 2011 at 5:14 am

  #1334901

  USE <DatabaseName>

  GO

  GRANT SELECT ON <TableName> TO <UserName>

  GO