So we have some compliance requirements around who/what can see data in a database. Ideally we'd like it only to be usable by the service that is in question -- and the user authorized to see the data from our system (ie, external user with a login to their own data).

We run a lot of oracle here but also SQL server and others. Appreciate as generic an answer as I can get.

closed as too broad by Sven May 15 at 15:57

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 2
    as generic as possible is what we don’t want here. Ask specific questions about specific problems and situations. That said, this topic might better fit on Database Administrators anyway. – Sven May 15 at 15:59