473,320 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Hide databases in SQL EM from dbo owner

If i create a new SQL login and give that login db ownership for a test db.
When that user adds my SQL Server through his own SQL EM, why does he/she
also see all other objects (databases, sql security logins, DTS, ...)?

Is there a way for the user to open SQL EM but only see his/her db and
nothing
more?

Thank you
Jul 20 '05 #1
4 2532
In article <0F*********************@news20.bellglobal.com>,
se****@nospam.ehmail.com says...
If i create a new SQL login and give that login db ownership for a test db.
When that user adds my SQL Server through his own SQL EM, why does he/she
also see all other objects (databases, sql security logins, DTS, ...)?

Is there a way for the user to open SQL EM but only see his/her db and
nothing
more?


Now you know why they call it "Enterprise Manager". If you don't want
someone gaining access to your database, and you don't trust the users
with SA access then you are screwed. Even if you did hide it, somehow,
the SA account can gain access to it.

Only DBA's should be using EM.

--
--
sp*********@rrohio.com
(Remove 999 to reply to me)
Jul 20 '05 #2
On Thu, 16 Sep 2004 19:50:20 -0400, serge wrote:
Is there a way for the user to open SQL EM but only see his/her db and
nothing
more?


Hi Serge,

Not as far as I know. This information is available in tables in the
master database that everybody has access to. EM presents it nicely, but
it's possible to retrieve the same information by executing some queries
in Query Analyzer, osql or any other tool.

Users can see the name of the database, but not the contents, so you
shouldn't be too worried about it (unless you have a database called
MyPlansToRipOffTheBoss - but you could always choose a less obvious name).

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
Jul 20 '05 #3
Hi

EM is not really something you should be giving to just anybody! If you
really want to do this, then you may want to create a separate instance,
although this may be a heavy overhead if you require more than a couple.

John
"serge" <se****@nospam.ehmail.com> wrote in message
news:0F*********************@news20.bellglobal.com ...
If i create a new SQL login and give that login db ownership for a test db. When that user adds my SQL Server through his own SQL EM, why does he/she
also see all other objects (databases, sql security logins, DTS, ...)?

Is there a way for the user to open SQL EM but only see his/her db and
nothing
more?

Thank you

Jul 20 '05 #4
Thank you for the responses.

What about this SQL Web Data Administrator that can be run
using IIS or VS.Net.

Has anyone tried this? If so, maybe through this web front-end, there
might be better ways to control which tools to show for the users?

Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Hai-Chu Hsu | last post by:
Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old...
5
by: Gary | last post by:
I'm working on an app where I need to access a table from 2 different databases (same MS-SQL box). What I need is to have a SELECT string with an INNER JOIN based on these 2 tables. If they were...
2
by: Flo | last post by:
Hello I want to be able to show/hide an application that is running. When i am getting the handles corresponding to an MS Office application (Excel for example), it appears that i get a handle...
1
by: CSN | last post by:
Not a big deal, but I'm transferring a dumpall and it's choking on databases where the owner no longer exists. Maybe it shouldn't be possible to delete a user while it still owns databases, or...
2
by: Jonathan Villa | last post by:
Is it possible to create a database to be owned by a user that only exists to postgresql or do they have to be shell accounts as well. $ createdb --owner=testcon testdb but the owner ends up...
7
by: Fred Exley | last post by:
I have a traditional application using a database and procedural code that works fine. I'm re-writing it using the OOP methodology, just to see how this may be the better way to do things. I...
1
by: magmike | last post by:
Looking to do sort of the same thing you see on websites, but on access form, where when a value is selected from a drop down list, if it matches the desired value, certain form fields appear. ...
5
by: ewokspy | last post by:
I have 2 MS Access 2003 databses, one is third party so I cannot modify it, and the other is a db I designed to grab the info I need and add a few other columns. I am writing a C# program to perform...
2
by: amplegamble | last post by:
Hello, As the title says I need to find out the owner of database on both sql 2000 and 2005. I found a query which works great on sql 2005.. select suser_sname(owner_sid) from sys.databases where...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.