Show only permitted database

From: Dennis (Dennis_at_discussions.microsoft.com)
Date: 04/16/05 

Date: Sat, 16 Apr 2005 07:35:06 -0700

Hi,

I am new to SQL Server and I need helps on solving the following problem.

How am I going to allow the user to see only their permitted database in
enterprise manager. I wish to hide all the non-permitted database and other
options such as Data Transformation Services, Security, Management,
Replication and etc from the users in enterprise manager?

Thanks.

Dennis.

Relevant Pages

  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)
  • Re: Tools with/for Express
    ... Enterprise Manager does not work with SQL Server 2005. ... Analyzer is pretty dumb and just passes on what you type, ... But Enterprise Manager tries to write it's own code and it doesn't use SQL ... I then attempted to use Query Analyzer. ...
    (microsoft.public.sqlserver.tools)
  • Re: Replication problems
    ... machine than SQL Server as you must reference a share on the machine and not ... You can't create a publication due to the 1038 error. ... > not yet have any Publications in my Enterprise Manager. ... > start the SQL Server Agent service manually". ...
    (microsoft.public.sqlserver.ce)
  • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
    ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
    (microsoft.public.isaserver)
  • Re: login security question
    ... > I have an application which connects to the SQL server. ... Use Enterprise Manager to access the database / roles. ... Give the Application Role the appropriate permissions. ... what the stored proc is called) using the secret password for the App Role ...
    (microsoft.public.sqlserver.server)