July 3, 2013 at 7:49 am
I would like to know if there is a way to stop users from being able to see the tables of my database by stopping users from being able to expand the Table node in the Object Explorer?
July 8, 2013 at 1:53 am
I don't think you can disable the expanding option, but users can only see those tables, which they have select permission on.
So unless you give select permission to either public or the user, they won't see any tables.
[font="Verdana"]Markus Bohse[/font]
July 8, 2013 at 1:58 am
Correction:
User can only see tables where they have any permission on, doesn't have to be "Select".
[font="Verdana"]Markus Bohse[/font]
July 9, 2013 at 1:07 pm
Tested it too.
As Markus said unless you give select permission to either public or the user, they won't see any tables.
July 9, 2013 at 1:41 pm
Just curious...you have users that have SSMS installed but you don't want them to be able to see the tables? What are you trying to accomplish here?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 10, 2013 at 2:24 am
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply