Hi people We have a developer who is working remotely. He has access to our company's SQL and server. The concern is about him having access to all data in SQL. Is there a way such that he can make changes to table structure but cannot see what's inside the
table? Things like customer name, profiles etc. are sensitive and we don't want him to take a peek, let alone export them out of server. Thanks all!
Do you have a test database? If not, ask yourself why anyone at all will be attempting to change a database structure on a production database without testing it first.
If so, give him access to the test db. Make him provide you with the actual sql for any alter table, etc things that have to be done. Then have your local dba run them on your production db.
yyylim
0 Points
2 Posts
SQL developer must not have access to DB data
Nov 08, 2012 07:04 PM|LINK
Dan Bracuk
Contributor
3970 Points
1096 Posts
Re: SQL developer must not have access to DB data
Nov 08, 2012 07:23 PM|LINK
Do you have a test database? If not, ask yourself why anyone at all will be attempting to change a database structure on a production database without testing it first.
If so, give him access to the test db. Make him provide you with the actual sql for any alter table, etc things that have to be done. Then have your local dba run them on your production db.
molly_c
Participant
1590 Points
401 Posts
Re: SQL developer must not have access to DB data
Nov 14, 2012 01:38 AM|LINK
Change table structure will affect your data in the original table. Make sure the changed column's datatype is suitable to old one.
Molly
It's time to start living the life you are imagined.