Restricting Users View in Enterprise Manager

From: Julian (anonymous_at_discussions.microsoft.com)
Date: 10/15/03 

Date: Tue, 14 Oct 2003 18:02:43 -0700

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: Replacing Workgroup Security with Domain Groups/Acounts - is it possible
    ... If I try to create MDE file and Access returns message: ... > If your sole purpose for implementing workgroup security was to prevent ... Even if you did need to restrict use of certain ... permissions on your SQL database could serve to limit ...
    (microsoft.public.access.security)
  • Re: db_owner - Unauthorized Size increase
    ... permissions will suffice? ... > Kevin Connell, MCDBA ... >> How can i restrict the maximum size of the database for a db_owner? ...
    (microsoft.public.sqlserver.security)
  • Secure Login Form
    ... I need to restrict access to certain forms on my database. ... Dim stDocName As String ... intLogonAttempts = intLogonAttempts + 1 ...
    (microsoft.public.access.security)
  • Re: Restricting access to records
    ... Titchfield, South Molton, Irvine and Euclid - how can we restrict someone ... We have a database that for a user to access it they must have a username, ... Dim strSQL As String ...
    (microsoft.public.access.security)
  • Restrict Browsing using Word2000
    ... We use network security & group policy to restrict ... browsing to selected directories on our server. ... database directory, select a database file then delete it ...
    (microsoft.public.win2000.security)