I want to revisit a question I have raised: how to restrict access to certain databases that are located on a server. In an office environment this ability is critical. Currently, as I understand it, if a person on a network can access a server, then he/she can download any database on that server. I wonder if this can be changed? I had two ideas, but I have no idea if either is feasible.
- Restrict Server Admin access with a password.
- Prevent Server Admin access to those logged in as a User.
- Any other ideas?
I had a earlier post about using more than one server which would permit a hierarchical approach to database access, but that has some disadvantages–requiring more than one computer to host servers, for example.
What do you think, Jim?