October 16, 2007 at 10:11 am
I'm using a shared SQL Server 2005. The admin added a user for me and set permissions on some 10 tables for read only, for that user. Great!
Problem: How do I, or the admin, hide all the system tables from that user? They've assured me they'd do no harm, but I'd rather get them out of the way. How is that done?
thanks!
October 16, 2007 at 12:02 pm
Try this:
On the Tools menu, click Options.
On the Environment/General page, select Hide system objects in Object Explorer, and then click OK.
In the SQL Server Management Studio dialog box, click OK to acknowledge that SQL Server Management Studio must be restarted for this change to take affect.
Close and reopen SQL Server Management Studio.
Greg
Greg
October 16, 2007 at 12:22 pm
Management Studio is on the client end. I have many users logging in with username [merchant] to access data I provide.
I want to hide the tables from those users on the server side. Is that possible?
thanks
October 16, 2007 at 2:56 pm
When you say "hide access", are you referring to client connections or the ability to query the tables? All client access to see the tables would be done through SSMS as described by Greg. Any ability to query would be controlled through permissions.
If you are talking about system tables, DON'T MESS WITH THE PERMISSIONS !!!!
October 16, 2007 at 3:06 pm
I was hoping to hide from view for those users. It's easier to tell them to login and link to all tables vs login and link to these 10 tables out of the 50 showing.
thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply