Hiding MS SQL 2000 databases in Enterprise Manager

Question

Hiding MS SQL 2000 databases in Enterprise Manager

YukonDR

SSC Journeyman

Points: 96
More actions
April 30, 2006 at 6:29 pm

#152944

I work for a company that offers web hosting services. We are interested in showing for each SQL Server 2000 login only the databases for which he/she has access and hide the rest of them in Enterprise Manager. Is there a way to hide the databases for which a login doesn't have permissions to access?

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

No, you can't hide user databases in Enterprise Manager. You can create a named instance for each customer or you can provide a front-end app that only shows the customer's database.

Greg

YukonDR SSC Journeyman Points: 96 More actions · Answer 2

I figured out it wasn't possible, but I wanted to be sure.

Thanks a lot Greg!!!

TimS Ten Centuries Points: 1165 More actions · Answer 3

It is possible in SQL 2000.

Tim S

See MS Info AT

http://support.microsoft.com/default.aspx/kb/889696

See my post at

http://groups.google.com/group/microsoft.public.sqlserver.security/browse_frm/thread/24c50b41fc85a144/9e4259b3fc8ba957?lnk=st&q=stahta01&rnum=30&hl=en#9e4259b3fc8ba957

YukonDR SSC Journeyman Points: 96 More actions · Answer 4

YukonDR

SSC Journeyman

Points: 96

May 1, 2006 at 4:12 pm

#635229

Thank you very much Tim, it worked!!!!!!!!

Greg Charles SSC-Forever Points: 45403 More actions · Answer 5

I stand corrected. Now that I've looked at sp_MSdbuseraccess and the MS article, I understand how it works. Tim, does your modification hide databases with the guest user, also? That's what it looks like, but I wanted to be sure.

YukonDR, the caveat about modifying a system stored procedure is that it might be undone by an upgrade or hotfix, so be aware of that.

Greg

TimS Ten Centuries Points: 1165 More actions · Answer 6

It should hide the databases with DB_ID less than 5 even if they have the guest user in them unless the user is in a server role.

I have not every used my code in production, I just wrote it and tested it on a test server and it worked OK when I read the newgroup post from a while back.

Tim S

Greg Charles SSC-Forever Points: 45403 More actions · Answer 7

Thanks for the explanation. This must be run when a user starts Query Analyzer also because I don't see all databases in the object browse when I log on as a user with limited access.

Greg

YukonDR SSC Journeyman Points: 96 More actions · Answer 8

Thank you guys for the valuable information!!

YukonDR

Hiding MS SQL 2000 databases in Enterprise Manager

Cookies on SQLServerCentral