May 14, 2009 at 11:48 pm
What I'm looking to do is to hide specific tables from an end user. We have a rather large data warehouse where there are a lot of tables which are used only for calculations or joins on an end table.
All I want to do is show only the tables that are relevant to the end user, and hide all the other tables.
There is a shared login that the end users will use to access the Warehouse.
May 15, 2009 at 1:26 am
By design, SQL Server 2005 and above only shows the objects which a user has permissions for. So in your example, if you create a shared login which has SELECT permissions against the relevant tables, the user will only see those tables. The other tables will not be seen.
K. Brian Kelley
@kbriankelley
May 17, 2009 at 7:11 pm
Unless I'm setting it up incorrectly, this doesn't work.
I have a shared user that has db_dataread and db_datawriter access (they will need to write to the tables they can see) I have denied SELECT permission (in the Securables tab under properties) to certain tables and allowed on others.
When I log in to SQL Server, the user can still see those tables. They are unable to run queries against them, but can still view them
May 17, 2009 at 7:41 pm
I can't seem to delete the last post. I had the user set up ad bulkadmin. Removed that and it solved the problems
May 18, 2009 at 10:30 am
pogla.the.grate (5/17/2009)
I can't seem to delete the last post. I had the user set up ad bulkadmin. Removed that and it solved the problems
I do not think deleting post is allowed. You can only Edit.
-Roy
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply