ssql server DB hide?

Hello DEAR Gurus,
I am trying to put important info on a separate new DB in sql server. How do I set up the new DB so that only I or people I choose can see what’s in that DB? I need to make sure not everyone with user or admin access to that server can see those tables unless I specify. Can someone please guide, is this a complex thing to do? How do I go about doing this?

thanks
RayneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
I need to make sure not everyone with user or admin access to that server can see those tables unless I specify.
Admin access to that server or to that SQL Server? If someone has admin rights on a SQL Server instance you can't do nothing about that.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RayneAuthor Commented:
Encript dB not possible....so they can see the dB from outside but when they open the db, they don't see nothing
0
RayneAuthor Commented:
Encriprion of db?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Why are you giving admin privileges on users that you want them to have restrict access?
0
RayneAuthor Commented:
i am not the one doing that
0
RayneAuthor Commented:
i don't have any control over it, someone esle does it, i just happen to be a sys admin too
0
PatHartmanCommented:
This question doesn't have anything to do with Access.  It has to do with securing SQL Server.  If the server is correctly secured, you won't be able to see the tables from Access although, you will probably be able to see the database.  Regardless, you won't be able to link to any of the tables without a UID and password with the correct authority.
0
RayneAuthor Commented:
"if the server is correctly secured, you won't be able to see the tables from Access although, you will probably be able to see the database"  this si exaclty i want - how do i accomplish it?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.