1
kudos
spam Kudos Remove

SQL Server DBA practices: Show or hide specific table in management studio?

published 450 days, 4 hours, 12 minutes ago posted by sasa 459 days, 5 hours, 43 minutes ago
Sunday, February 27, 2011 7:08:57 AM GMT Friday, February 18, 2011 5:37:59 AM GMT
During a recent DBA consulting engagement one of the users at a client posed a question stating, "how do we hide certain tables on Management Studio even though the set of users do need read/write privileges on those tables?". For a moment I was thinking permissions and privileges to set out, but there is more to the question asked above. As it states the users do have required permissions on those tables. The mentioned tables consist confidential information about the monetary transactions where...(read more)
category: News | clicked: 2 | | source: sqlserver-qa.net | show counter code
tags: beginners, Best Practices, DBA, executesql, Management Studio, SQL Server, SSMS, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup