March 20, 2008 at 2:53 pm
Hi,
My goal is to let users run queries with MS Excel. I have created the user but when asked what views they want to use in Excel they see too many views (such as the sys and XML ones). When I try to set up the securables they don't seem to save. I click ok then when I reopen them there is nothing there.
Any help would be great. Thanks in advance.
(If this topic already exists please post the link. Thanks.)
I forgot to mention that I am using SSMS 2005.
Here is what I have so far:
1. My dbo schema has the role group in the permission section granting select. The schema owner is dbo.
2. The role has the views defined that are supposed to be visible to the users in that role (which are not visible). The role owner is dbo.
3. The users default schema is dbo and is in the group.
For some reason all views are still visible when connecting with this user. Where am I going wrong?
Thanks again. Thought this extra info would help.
March 21, 2008 at 10:04 am
All users are placed into the public role and public has select rights on all the system views. You would need to explicitly DENY select to the user/role they are using to connect with.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 21, 2008 at 12:39 pm
Where would I deny it for the group? In the role, in the owner of the role, and how? I am sorry but I am new to permissions and they seem to be very confusing when you have no clue.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply