Re: Enterprice manager.

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/28/05


Date: Sun, 28 Aug 2005 08:32:11 -0600

Hi,

This is not possible in SQL 7.0 and SQL 2000.

Thanks
Hari
SQL Server MVP

"Steinarr G." <steinki@dynamicsystems.dk> wrote in message
news:eH$JN3JrFHA.3264@TK2MSFTNGP12.phx.gbl...
> Hi there.
>
> When i allow remote connection to my sql with Enterprice Manager .. users
> see
> the list of all databases but can only enter there own .
>
> How can i make it so, so they only see there own database witch there user
> has
> access to ?
>
> Regards.
> Steinarr.
>



Relevant Pages

  • Re: Trying to Move Group - SQL Instance Wont Start
    ... You can do a maintenance install and add the new nodes. ... You will have to undo the manual allowed nodes settings and then follow the instructions in "maintaining a failover cluster" for recovery from failure scenario 1. ... SQL 2000 on Windows Server 2003 allows up to four nodes in a cluster so you should be good to go. ... > Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Breaking a Sql Cluster
    ... If you are not going to have any extra SAN space, ... then remove the old instance and install a *clustered* SQL ... 2005 instance on that same cluster. ... SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error -2147217900: failed to create SQL database
    ... We ran profiler to see what commands is the MSI passing to create the DB. ... SQL Server MVP ... database: ApplicationDb, ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Error -2147217900: failed to create SQL database
    ... SQL Server MVP ... we rebuilt the SQL cluster network today. ... database: ApplicationDb, ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Breaking a Sql Cluster
    ... "Tom Moreau" wrote: ... SQL Server MVP ... We have one local and one named instance of SQL 2000 on the cluster at ...
    (microsoft.public.sqlserver.clustering)