Re: Show only permitted database

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 04/16/05 

Date: Sat, 16 Apr 2005 15:55:15 +0100

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: Viewing default db role permissions
    ... > whether that user or role has access to various objects in the database ... > the database in Enterprise Manager, going to the "Role" tree item, ... > checkmarks representing what the role/user has access to and red X's ... > permissions of each of these roles from the SQL Server documentation, ...
    (microsoft.public.sqlserver.security)
  • SQL Server does not exist or access denied
    ... I get the error both in application code and from Enterprise Manager. ... The database is LOCAL. ... Microsoft SQL Server 2000 Developer Edition SP4 ... Once it fails, it will fail ...
    (comp.databases.ms-sqlserver)
  • SQL Server does not exist or access denied
    ... I get the error both in application code and from Enterprise Manager. ... The database is LOCAL. ... Microsoft SQL Server 2000 Developer Edition SP4 ... Once it fails, it will fail ...
    (comp.databases.ms-sqlserver)
  • Re: Maybe the Records Are There After All
    ... Run DBCC UPDATEUSAGE to correct the row count display in Enterprise Mangler. ... Senior Database Administrator ... I support the Professional Association for SQL Server ... > Enterprise Manager and it gave me the sensation that ALL of the data had ...
    (microsoft.public.sqlserver.server)
  • Re: major security concern - any sql user with minimal permission can see code for all stored procs
    ... remove select access (and execute access on selected stored procs in the ... things - and hence has enterprise manager - then this approach won't work. ... If you just want to lock down a database, then I'd try my approace - lock ... >> connected from a remote location to my SQL server at port 1433, ...
    (microsoft.public.sqlserver.security)