On Thu, 16 Sep 2004 19:50:20 -0400, serge wrote:
Is there a way for the user to open SQL EM but only see his/her db and
nothing
more?
Hi Serge,
Not as far as I know. This information is available in tables in the
master database that everybody has access to. EM presents it nicely, but
it's possible to retrieve the same information by executing some queries
in Query Analyzer, osql or any other tool.
Users can see the name of the database, but not the contents, so you
shouldn't be too worried about it (unless you have a database called
MyPlansToRipOffTheBoss - but you could always choose a less obvious name).
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)