Re: Show only permitted database
From: Dennis (Dennis_at_discussions.microsoft.com)
Date: 04/16/05
- Next message: Dennis: "Guest userin Master and tempdb database"
- Previous message: Jasper Smith: "Re: Show only permitted database"
- In reply to: Jasper Smith: "Re: Show only permitted database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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.
>
>
>
- Next message: Dennis: "Guest userin Master and tempdb database"
- Previous message: Jasper Smith: "Re: Show only permitted database"
- In reply to: Jasper Smith: "Re: Show only permitted database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|