Re: Hide Objetcts from users

From: Carlos Eduardo Rojas (carloser_at_mindspring.com)
Date: 07/28/03 

Date: Mon, 28 Jul 2003 10:02:32 -0400

Alex,
Unfortunately, Enterprise Manager doesn't provide a way for administrators
to hide database objects to users based on permissions. The only thing you
can do is hide system objects in enterprise manager. To enable this setting,
go to the server name, right-click on it and choose edit sql server
registration properties, then you'll see an option that reads show
system databases and system objects. 

-- 
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 Programming by Example
"Alex Decarli" <alex.decarli@computeasy.com.br> wrote in message
news:06ee01c35508$e7c93b50$a301280a@phx.gbl...
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: 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)
  • 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)
  • Re: Maybe the Records Are There After All
    ... Run DBCC UPDATEUSAGE to correct the row count display in Enterprise Mangler. ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > Enterprise Manager and it gave me the sensation that ALL of the data had ...
    (microsoft.public.sqlserver.server)
  • Re: major security concern - any sql user with minimal permission can see code for all stored procs
    ... remove select access (and execute access on selected stored procs in the ... things - and hence has enterprise manager - then this approach won't work. ... If you just want to lock down a database, then I'd try my approace - lock ... >> connected from a remote location to my SQL server at port 1433, ...
    (microsoft.public.sqlserver.security)