August 20, 2014 at 12:14 pm
Is there a way to hide databases that users don't have access to? I read articles on denying the public role 'VIEW ANY DATABASE' and make the user the owner. This won't work for us because I don't want to add them as the owner and I will be handling access levels via groups. We have 7 departments that will using 2 instances.
Thanks.
August 20, 2014 at 1:17 pm
bucknick (8/20/2014)
Is there a way to hide databases that users don't have access to? I read articles on denying the public role 'VIEW ANY DATABASE' and make the user the owner. This won't work for us because I don't want to add them as the owner and I will be handling access levels via groups. We have 7 departments that will using 2 instances.Thanks.
If they don't connect access it will still appear in the dropdown of databases but will throw and exception if is chosen that the user does not have permission.
_______________________________________________________________
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/
August 20, 2014 at 2:04 pm
Exactly. The goal is to only see the databases they have access to but based on the readings, this is not an option unless you make the user the owner. As mentioned, we are using groups for our developers and don't want to make them the owner.
August 20, 2014 at 2:50 pm
bucknick (8/20/2014)
Exactly. The goal is to only see the databases they have access to but based on the readings, this is not an option unless you make the user the owner. As mentioned, we are using groups for our developers and don't want to make them the owner.
Does it really matter if somebody else knows about the existence of another database that they can't access? I mean these are people that are trustworthy enough to have access to SSMS.
_______________________________________________________________
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/
August 20, 2014 at 3:42 pm
The issue from their side is they don't want to "weed" through all the other databases to find their own. So.... that is what I'm dealing with.
August 20, 2014 at 3:45 pm
bucknick (8/20/2014)
The issue from their side is they don't want to "weed" through all the other databases to find their own. So.... that is what I'm dealing with.
Ahh gotcha. I don't know of a way to limit the list of databases other than what you already described. Maybe there are some addins out there that can do that though.
_______________________________________________________________
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/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply