April 16, 2003 at 6:14 pm
Newb here... I didn't see a search for the forums but I searched the site. I am looking for a way (it seems that SQL Server 2002 Enterprise doesn't support this natively) to hide any database that a user doesn't have access to. So, if a user has access to F00 database and they login all they will see in EM is the F00 database.
Any help?
April 16, 2003 at 6:34 pm
I think the answer to my question is no.
I think the better question is actually:
What do major hosting companies do to allow their customers access to SQL Server?
Are the customers/developers left on their own to use some other tool to access it and use TSQL to create and modify their tables?
April 17, 2003 at 9:53 am
I can only speak for the hosting company that services one of my clients...
They create the databases with the owner as the login given to each client. The client is allowed to connect via EM or QA through the IP address using the login specified.
Yes - we can see hundreds of databases (bad in my opinion) in EM but can only access the one assigned to us.
I would like to see a better implementation...or understand the configuration changes to make it look like we were the only ones on the machine.
Guarddata-
April 17, 2003 at 12:35 pm
Though it might sound silly..but what i did once on such a situation was :
Asked the client to to connect through Access database and provide him with the login informatiom for that database only. So when he creates fileDSN or systemDSN he can link only the tables he has access to and can't see anyother databases.
April 18, 2003 at 5:04 am
The point is that sysdatabases in master can be read by any user who connects. Some apps will not show this but if they do
SELECT * FROM master..sysdatabases
it will return the full list.
The limiting factor is the fact they do not have access on the other databases.
This is no more of an issue than the fact you can see folders on a server you do not have access to.
EM does not limit their view of any database so they see them all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply