Re: Filter SQL Enterprise Manager

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 20:48:01 +0100

Hi Ivan,

You can't filter out the objects in SQL Server 2000 Enterprise Manager.
Everyone who can connect to the server can see all the databases (but of
course not all the data) and the DTS, Replication etc folders. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Ivan Mckenzie Rodriguez" <imck@serviport.com> wrote in message
news:%23lGyL6kIEHA.3820@tk2msftngp13.phx.gbl...
> Hi every one.
>
> Is it possible to filter the information that a user can see with SQL
> Enterprise Manager. For example, I have a user that has permision to a
> database but I don't want him to see the names of the other databases that
> exist on the server or the Data transformation Services folder, Managment
> folder, Replication folder, security folder, Support services and Metadata
> Services folder.
>
> In other words, I only want the user to see the database folder and in
that
> folder the database to wich he has permissions.
>
>
> Thanks a lot,
>
> Ivan Mckenzie
>
>
>
>
>

Relevant Pages

  • Re: Backup still not working
    ... So you may try to rebuild the RSM database if the ... > rename the existing files in this folder to a .old file extension, ... > this time unchecks "First Storage Group" under Microsoft Exchange Server. ... > 1) Open SQL Server Enterprise Manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: Build
    ... As Kalen already mentioned, there is no such thing "build" in SQL Server, that term is must be about "Building a Project or Solution in Visual ... here you are talking about a specific application which seems to need more than one database and noone here except for you knows about the sample application you are working on now. ... From what I've learned, there are actually several databases that exist for every "solution", located in the output folder and project folders. ... If you can explain what you mean by "build" and some examples of what files you refer to then we might be able to add some... ...
    (microsoft.public.sqlserver.setup)
  • Re: Build
    ... SQL Server 2005 Express ed starter kit, ... But the sample database ... located in the output folder and project folders (bin/debug folder and the ... you refer to then we might be able to add some... ...
    (microsoft.public.sqlserver.setup)
  • Re: Viewing default db role permissions
    ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
    (microsoft.public.sqlserver.security)
  • SQL Server does not exist or access denied
    ... I get the error both in application code and from Enterprise Manager. ... The database is LOCAL. ... Microsoft SQL Server 2000 Developer Edition SP4 ... Once it fails, it will fail ...
    (comp.databases.ms-sqlserver)