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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

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
RayneAuthor Commented:
Encriprion of db?
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Why are you giving admin privileges on users that you want them to have restrict access?
RayneAuthor Commented:
i am not the one doing that
RayneAuthor Commented:
i don't have any control over it, someone esle does it, i just happen to be a sys admin too
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.
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?
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.