This content has been marked as final. Show 3 replies
1) Web Based Interface ?.
2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)
3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)
4) Standard Tools / Utilities / Others ??.Oracle has Database vault security product to prevent high privilege user to access users data.
it has GUI mode to configure it but this product required license.
Other than DB Vault ( Costly Option ) , Any other option by Grant / Revoke possibilities ?.
In SQL Servers , We were getting that options
I'm not quite sure that I understand what you mean by "DBA vendor" and "customer DBA". I take it those are two separate roles? Do both roles need to be granted the DBA role? Or could the "DBA vendor" role be granted a more limited set of privileges that don't involve, for example, granting the privileges to view the data in every table in the database? What, exactly, does the "DBA vendor" role need to be able to do?