Re: Hide databases in EM/QA

Sue,

Maybe I'm doing something wrong, but this seems to work and provide a list
of all databases on the server EVEN if the login does not have permissions
for the database.

SELECT name
FROM master..sysdatabases

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:t810k2dq7tpgrmsi4lkvivgvevss73fs7a@xxxxxxxxxx
This is only true for Enterprise Manager. The users will be
able to see all the user databases although they can only
access those that they have been granted access to
explicitly or implicitly (groups, guest account
considerations).
In Query Analyzer, the databases will be restricted or
filtered to those which the user has access to.

-Sue

On Wed, 25 Oct 2006 12:18:33 -0700, "Arnie Rowland"
<arnie@xxxxxxxx> wrote:

Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query
Analyzer, you will find that almost impossible.



.

Relevant Pages

  • Re: Enterprise to Standard
    ... "Arnie Rowland" wrote: ... Most good judgment comes from experience. ... All I'm doing is uninstalling EE and installing SE on my current sql ... My plans were to backup the databases, uninstall EE, install SE (with ...
    (microsoft.public.sqlserver.setup)
  • Re: How do I find out SQL Server instance name and username?
    ... the application provider. ... I suspect that they have the MSDE server and ... databases 'locked' down to prevent customers from 'accidentally making ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.msde)
  • Re: Enterprise to Standard
    ... Master, model, msdb, tempdb are also installed. ... User databases 'should' not ... installation. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • RE: Hiding MS SQL databases in Enterprise Manager
    ... analyzer enumerates the databases). ... Query Analyzer goes further and checks permissions before ... around htis problem is to multiple virtual instances of SQL server for each ... > security issue, I would like to set it up so that users can only see ...
    (Focus-Microsoft)
  • Re: Move Existing SQL Server to a New Server
    ... Restore master, then model, then msdb then the user ... databases during start up ... I do not want to move all user databases, ... > moving or restoring the databases - especially related to ...
    (microsoft.public.sqlserver.setup)