Blackbaud provides read-only roles for both products using Microsoft SQL Server 2000. The Financial Edge has the role “blackbaud_read_only” and Raiser’s Edge 7 has the role “RE_ReadOnly”. Your database administrator can use these roles to create a Read Only login for use with your RODBA related product.
Note: The MSDE version of SQL Server 2000 does not include the SQL Server Enterprise Manager. Clients using the MSDE version must sign up for Read Only Database Assistance to directly access the back end of the database.
Following are two scenarios involving linking an Access 2000 database to a Microsoft SQL Server 2000 Enterprise edition database. Blackbaud strongly encourages organizations to assign read-only rights to any user intending to directly access the back end of the database.
- Full Rights:
If the linked Access 2000 database is created using a Database Administrator login the user can freely delete rows in a Table or Select Query. You can highlight a row in a table and select delete. Or, you can highlight a row in a select query and select delete.
When you highlight a row in a table or select query, and select delete, the following message appears:
‘You are about to delete 1 record(s). If you click Yes, you won’t be able to undo this Delete operation. Are you sure you want to delete these records?’
If the user clicks Yes, the record is deleted from the Blackbaud database -- not just from the Table or Select Query. The record can only be retrieved by restoring to a backup.
There is no way to track records deleted in this way. Not only does modifying the database through the back end increase the risk of database corruption, it is in violation of the licensing agreement.
- Read-Only Rights:
If a linked Access 2000 database is created using a Read Only login, the user is not able to delete rows from a Table or Select Query. The following message appears:
‘ODBC-delete on a liked table ‘dbo_tablename’ failed [Microsoft][ODBC SQL Server Driver][SQL Server] DELETE permission denied on object ‘tablename’,database ‘Database Name’, owner ‘dbo’.(#229)’
The message indicates the user does not have rights to delete the record.