Re: Hide databases in EM/QA
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Thu, 26 Oct 2006 09:09:57 -0700
While I agree that the databases won't show up in the Object Explorer, I
read the OP's question as "How can I hide all other databases from client?",
and I replied that that was virtually impossible.
Your rejoinder seems to indicate to the OP that is was safe to use QA since
"the databases will be restricted or filtered to those which the user has
access to."
And I disagree that is it possible to 'hide all other databases" while using
QA.
--
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:mr91k2921p9mn4ousa61lj4govgj0brt44@xxxxxxxxxx
That does not affect the view. Look at the available
databases in QA from the databases drop down.
-Sue
On Wed, 25 Oct 2006 22:48:19 -0700, "Arnie Rowland"
<arnie@xxxxxxxx> wrote:
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
.
- References:
- Hide databases in EM/QA
- From: slousch
- Re: Hide databases in EM/QA
- From: Arnie Rowland
- Re: Hide databases in EM/QA
- From: Sue Hoegemeier
- Re: Hide databases in EM/QA
- From: Arnie Rowland
- Re: Hide databases in EM/QA
- From: Sue Hoegemeier
- Hide databases in EM/QA
- Prev by Date: Re: Permission for a role...
- Next by Date: how to disallow a user from creating and modifying trigger but can creating and modifying stored procedure
- Previous by thread: Re: Hide databases in EM/QA
- Next by thread: alter login on Windows user groups
- Index(es):
Relevant Pages
|
|
