August 27, 2009 at 1:36 pm
We have started having some weird problems here. SQL Server Management Studio is not displaying the list of databases in the object explorer. However the databases are accessible from Query Analyzer running USE DB_Name command. This is happenning to all the accounts that are not administrators. Does anyone know what the deal is with SSMS to act like this? Thanks in Advance.
August 27, 2009 at 1:45 pm
Does it give you any error when you connect to a server from Object Explorer ??
August 27, 2009 at 1:48 pm
No it does not give me any error. Would there be any command that could be barring all these logins from viewing the databases in the object explorer?
August 27, 2009 at 1:58 pm
Does it occur only at your end or did you try connecting to the server from any other machine ??
August 27, 2009 at 2:02 pm
It happens where ever you connect from. When I connect from my machine as an admin I see all the databases listed. But when I use the other login that has db_owner access to two of the user databases, I cannot see any of the databases listed besides the system databases.
August 27, 2009 at 3:09 pm
Has somebody by chance tweaked with the public role in an effort to secure the databases and server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 3:13 pm
USE master
--revoke VIEW ANY DATABASE from public
grant VIEW ANY DATABASE to [public]
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 28, 2009 at 6:18 am
This does not do the trick either. There seems to be something else that is not letting these logins to view the database.
August 28, 2009 at 8:36 am
It is finally fixed. Someone had messed up with the public role. View any database was granted but view any definition was denied. Since deny takes precedence over grant all the databases were not being displayed even though they had access to it.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply