Re: Show only permitted database

From: Dennis (Dennis_at_discussions.microsoft.com)
Date: 04/16/05 

Date: Sat, 16 Apr 2005 08:20:03 -0700

Hi Jasper,

Thanks for your info.

Dennis.

"Jasper Smith" wrote:

> For the databases, have a look at
> http://support.microsoft.com/default.aspx/kb/889696
> DTS designer in EM is client side. There is nothing to prevent anyone
> creating a DTS package however they will not by default be able to save it
> to a server (assuming you remove the guest user from msdb). Even though they
> can see something in EM does not mean they can modify it. There is no real
> metadata security in SQL2000, things have improved a lot in that area in
> SQL2005
>
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Dennis" <Dennis@discussions.microsoft.com> wrote in message
> news:ACBAC424-87A4-478D-9FEC-F9591DDBE555@microsoft.com...
> > Hi,
> >
> > I am new to SQL Server and I need helps on solving the following problem.
> >
> > How am I going to allow the user to see only their permitted database in
> > enterprise manager. I wish to hide all the non-permitted database and
> > other
> > options such as Data Transformation Services, Security, Management,
> > Replication and etc from the users in enterprise manager?
> >
> > Thanks.
> >
> > Dennis.
>
>
>

Relevant Pages

  • Re: Extended Stored PRocedures
    ... "Jasper Smith" wrote in message ... > have improved a lot from vanilla SP2 and previous. ... > affect the functioning of SQL Server. ... > "Stephajn Craig" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot change installation path sql2005 (final release)
    ... Jasper Smith (SQL Server MVP) ... >>> HTH ... >>> Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.setup)
  • Re: Simple questions
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... option to create the destination table. ... can I use the DTS Designer package to preserve the ... autonumber in Access and, going forward, will be an identity column in SQL ...
    (microsoft.public.sqlserver.dts)
  • Re: xp_sqlmaint -CkDB SET options error
    ... > Jasper Smith (SQL Server MVP) ... >> Server Driver]DBCC failed because the following SET options ... >> incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'. ...
    (microsoft.public.sqlserver.server)
  • Re: Obtaining Window login name from a trigger
    ... > this when an application uses a single service account is to use SET ... > Jasper Smith (SQL Server MVP) ... > login account. ...
    (microsoft.public.sqlserver.server)