Home Forums SQL Server 2012 SQL 2012 - General Stop users from expanding the Tables nodes in Object Explorer RE: Stop users from expanding the Tables nodes in Object Explorer

  • We were just looking at increasing our security for our databases. Some of our tables hold contact details such as telephone numbers, email addresses, etc. Apart from encrypting the entire data I was hoping there would be a way of creating a new user login with permissions restricting access to certain tables, including expanding and viewing the columns.