Solved

Security issue in SQL: How to hide  System Databases from certain users

Posted on 2010-09-06
5
343 Views
Last Modified: 2012-06-27
I am using SQL server 2008 . For securit reasons, I want  to restrict certain users' access  to a single database so that they can only see the ABCDatabase in Management studio once logged in.

And to achieve that:

1- I have created a new user.

2- Denied View all database rights to that user.

3-Set that user as Owner of ABCDatabase


Now on login that user cannot see other databases but is still able to see the system databases.

How can i hide those system databases from that user?

0
Comment
Question by:davnhm
  • 3
  • 2
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33610024
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 33610030
>but is still able to see the system databases.
sorry...
but you cannot hide those. they contain the meta-data that the user will need to query anyhow to see permissions etc .
0
 

Author Comment

by:davnhm
ID: 33610255
Thanks Angelll, but I am not entirely following you. What I need to do is give the user limited access to one database. I also want to remove any risk of them being able to access further databases. That is why I did not want them to see the system/security databases.

Is it possible to give such access to a single database without compromising security for the rest?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 33610318
>That is why I did not want them to see the system/security databases.
you cannot do that.

>Is it possible to give such access to a single database without compromising security for the rest?
seing the system/security db not comprimise anything else, as with limited permissions, the use cannot "do" anything more than seeing eventually that other databases existed: the user won't be able to connect to those databases, given that the login has not been mapped to those other databases, and does not have server role that would allow him to do so anyhow (aka sysadm)
0
 

Author Closing Comment

by:davnhm
ID: 33610363
Very helpful.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now