Re: Restricting Users View in Enterprise Manager

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 10/15/03


Date: Tue, 14 Oct 2003 22:02:43 -0400

It's not possible with SQL 2000.

-- 
Andrew J. Kelly
SQL Server MVP
"Julian" <anonymous@discussions.microsoft.com> wrote in message
news:048401c392b8$09f11c60$a401280a@phx.gbl...
> Hi,
>
> I have an SQL2000 user who is a dbo on a database. I want
> to restrict the view for this user so that they can only
> see their own database in Enterprise Manager.
>
> They can currently see the Master db, and others in the
> tree, and I want to hide these.
>
> Can this be done?
>
> Kind regards
>
> Julian.


Relevant Pages

  • Re: reindex or update stat
    ... change in the way the queries are run. ... Andrew J. Kelly ... SQL Server MVP ... > I have a database that will have couple thousands row inserted normally, ...
    (microsoft.public.sqlserver.server)
  • Re: Recovering SQL Server 2000 database without a backup
    ... >>Andrew J. Kelly ... >>SQL Server MVP ... >>> database and I don't have a recent backup. ...
    (microsoft.public.sqlserver.tools)
  • Re: Databaseaccess
    ... If that database is on the same server then just make sure the user from the ... >>You limit access by assigning rights to Logins. ... >>Andrew J. Kelly ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: How many databases can exist in sql server?
    ... Thanks Andrew. ... >32,767 per instance of sql server. ... >SQL Server MVP ... >> each user in their own database. ...
    (microsoft.public.sqlserver.setup)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)