Re: Hide Databases
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 01/16/04
- Next message: PC: "MS04-003: Security Update for Microsoft Data Access Components (MDAC) on cluster servers"
- Previous message: Vincent: "SQL server registration failed"
- In reply to: Alex Decarli: "Hide Databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 16 Jan 2004 19:22:29 -0000
This is not possible in SQL2000 Enterprise Manager. Metadata security is
pretty lax.You can choose to hide System databases if you wish , by going
into Edit SQL Server Registration Properties and uncheck Show system
databases and system objects
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Alex Decarli" <anonymous@discussions.microsoft.com> wrote in message news:079401c3dc1a$9849ce20$a501280a@phx.gbl... Hi Folks, I´m sharing a SQL Server 2000 SP3a with some users. These users are using Enterprise Manager and Query Analyzer at client side. It´s working well. My problem is: In Enterprise Manager view, users can see all databases, but only can manipulate your database. My Question: In SQL Properties, How can I hide Databases to non-owners ? Thanks Alex Decarli.
- Next message: PC: "MS04-003: Security Update for Microsoft Data Access Components (MDAC) on cluster servers"
- Previous message: Vincent: "SQL server registration failed"
- In reply to: Alex Decarli: "Hide Databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
