Hide Objetcts from users

From: Alex Decarli (alex.decarli_at_computeasy.com.br)
Date: 07/28/03 

Date: Mon, 28 Jul 2003 06:05:23 -0700

Hi folks,

Iīm using SQL Server 2000, SP3 and most recent update.
Thereīs some users with access a only own database
properlly.

But , by default, users can see all database, but canīt
access then.

How can I hide all objects in Enterprise Manager that
user canīt access ?

Relevant Pages

  • RE: Ent MS Svr 2003, Ent MS SQL Svr 2005, SQL SP2 failed at end
    ... Glad to know that you found the database default location referred to D: ... I recommend that you directly apply SQL Server 2005 SP3 since it is the ... to your SQL Server instance in SSMS and check the version number right ...
    (microsoft.public.sqlserver.setup)
  • Re: Full text indexing not working!
    ... then install SP3 for SQL Server 2000. ... after database restore some time back and got resolved after applying SP3. ...
    (microsoft.public.sqlserver.server)
  • Merge to Printer works but Merge to E-mail doesnt email
    ... I'm using Word 2003 SP3. ... I'm trying to mail merge out of a SQL server ... database table - with email addresses in the table. ... seems to work fine - but NO emails are created in Outlook. ...
    (microsoft.public.word.mailmerge.fields)
  • SQLSTTE = 08001 Microsoft OLE DB Provider for SQL Server [DBNMPNTW]
    ... My database is SQL Server ... 2000 with the latest SP on W2K SP3. ... having problem connecting to the database via the ...
    (microsoft.public.sqlserver.connect)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)