CODEWITHSUNDEEP
databaseoracle-databaseoracle-sqldeveloper
cloudtechnician
cloudtechnician

Reputation: 725

How to restrict user from Exporting results of a query in SQL developer

I want to create a DB read user and allow him to connect to DB via SQL Developer tool with below restrictions :

User shouldn't be able to query data or DB structure into the box locally and upload to somewhere externally using browser

The challenge we see here is although the read only user doesn't have the ability to export the schema dump but still he can query any table and export the output of that table from SQL developer because thats is a feature of SQL developer. How can I restrict the user to even export the output of a query from SQL developer.

Upvotes: 0

Views: 612

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22427

There's no way to do this.

Even if you prevented the ability of exporting the data, which might be possible by disabling features/extensions or removing JARs, they could still copy and paste the data out of a grid.

If you can't trust your users not to follow business rules, I wouldn't give them database accounts to begin with.

And if they abuse this, fire them. Sorry, that's not a technical answer, but I'm not sure this is really a technical question.

Upvotes: 3

Related Questions