Rayne
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Encriprion of db?
Why are you giving admin privileges on users that you want them to have restrict access?
ASKER
i am not the one doing that
ASKER
i don't have any control over it, someone esle does it, i just happen to be a sys admin too
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.
ASKER
"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?
ASKER