July 31, 2003 at 3:28 pm
I have a SQL Server 2000 server that has 425 databases on it. I have had developers repeatedly ask me if there is a way to have Enterprise Manager only show the databases that they have access to. I have done some research on the problem but have come up empty. Please advise.
Arthur Lorenzini
Arthur Lorenzini
July 31, 2003 at 3:52 pm
I've done this before for similar situations. It requires some changes to master stored procedures - notably sp_MSdbuseraccess.
I'm not sure of the implications of applying service packs thereafter. Would the customisation prevent service packs being applied, or would it be simply a case of reapplying the customisation if a service pack replaced sp_MSdbuseraccess?
I have documented scripts around here somewhere. Probably to big to post, so let me know if you'd like them emailed to you.
Cheers,
- Mark
Cheers,
- Mark
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply