Hi,
I would like to ask, is it okay/safe to install SQL Sandbox in Production?
If not, is there another best way to access Production data without compromising security?
Thanks in advance!
Regards,
Gabriel
Technically ou can install it in production, but it is important to make sure that only people have access to it that know how to use it and understand and data changes they apply.
I would advice to have the application always disabled through service center and only enable it when needed. After use disable it again.
There are two roles available on for querying data one for manipulating data. So you have some control to what extend who can do what with the application.
Furthermore their might be company security policy that forbids a tool.like this to be used in production. So always check with IT security or governance department.
Daniel
Thanks, Daniel!
This would be the best explanation I'm looking for.
Hi Gabriel,
Just to add, if SQL Sandbox is added on Production, then it does highlight/cautions near the query editor that you are working with the Production environment instance, but in no way stops you from committing any data changes via SQL statements.
Having SQL Sandbox has many pros when used responsibly. Completely agree with the inputs provided by Daniel.
Saurabh
Thanks, Saurabh!
Yea, It seems that I just need to make sure that the SQL Sandbox is only accessible from our Support Team. Since it can be disabled/enabled via Service Center like Daniel have mentioned + creating accounts with Roles for Viewing and Modifying data.