Revoke select permission

• sql Anand

  SSCommitted

  Points: 1597

  More actions

  October 15, 2011 at 1:17 am

  #258869

  hi,

  i create 2user(A,B) this 2user having permission to access (C_db)

  this C_db having 50 tables..

  now my A user can access only 25 tables,B user can Access next 25 tables..

  so i gave REVOKE SELECT ON <TABLE_NAME> FROM<USER_NAME>

  for all the tables correspondingly

  but now i connect with user A..that user will access that revoke select table also..

  so how to do revoke select in sql server 2008..

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 15, 2011 at 1:48 am

  #1394940

  Anand.A (10/15/2011)

  ---

  hi,

  i create 2user(A,B) this 2user having permission to access (C_db)

  this C_db having 50 tables..

  now my A user can access only 25 tables,B user can Access next 25 tables..

  so i gave REVOKE SELECT ON <TABLE_NAME> FROM<USER_NAME>

  for all the tables correspondingly

  but now i connect with user A..that user will access that revoke select table also..

  so how to do revoke select in sql server 2008..

  Duplicate Post. Please don't create multiple threads.

  table access in sql server 2008

  http://www.sqlservercentral.com/Forums/Topic1189660-391-1.aspx#bm1189707

• okbangas

  SSChampion

  Points: 11773

  More actions

  October 15, 2011 at 4:23 am

  #1394946

  Strictly speaking not Duplicate post, but similar topic. Unneccessary quoting is a bad habit too...

  As for the question: revoke removes the acl entry specified, whether it is a grant or a deny. Use deny to ovveride inherited grant permission.

  ---

  
  Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

  Concatenating Row Values in Transact-SQL[/url]