Your DBA's need to do their job and set permissions appropriately. If you give access to the data - and developers can run sql statements against the data, they can issue 'delete from' just as easy as 'select from'.

The other option would be to make a copy they can destroy.



>We need an easy-to-use tool that would allow one or two of our junior developers to query, and only query, a SQL Server database.
>
>We have Entreprise Manager on other desktops but our DBA's fear it is too powerful a tool for our junior developers (and have not intention of spending any time setting up permissions).
>
>Several tables contain about 5-20 GB if that's of any help.
>
>Any suggestions?
>
>TIA,
>Daniel