VSys One: Volunteer Management Software

Previous Topic

Next Topic

Book Contents

Book Index

Table Permissions Diagnostics

The Table Permissions Diagnostics tool verifies that for each VSys One table in your database, VSys can perform all of the required operations for normal use. When run, VSys will perform a SELECT, INSERT, UPDATE and DELETE operation on every table and log any errors that it encounters.

When to use this tool

Run this tool after changing any permissions on your SQL Server database to ensure that the currently logged-in user has the appropriate access to your SQL Server database. You may be instructed at other times by the VSys One support team to run this tool to diagnose the cause of other issues.
Linked Graphic

The appFields table is not tested for INSERT, UPDATE or DELETE.

The trace table requires INSERT and SELECT rights, but not UPDATE or DELETE. If one or both of these latter two is missing VSys will continue to work normally and users will be unable to purge the trace table (not necessarily a bad thing).

See Also

Tools

Apply Certification Automatic Creation Rules

Attachments Analyzer

Automatically Create Eligibility/Intake Checklists

Backing Up Your Data

Bulk Value Updater

Check for Duplicated IDs

Check for Program Updates

Check for Zip/Postal Code Updates

Concurrent Users Monitor

Create and Manage Data Encryption Keys

Database Merge Tool

Enter VSys One Registration Codes

Find Duplicate Assignments

Fix Recurring Assignment Detail Gaps

Letters Purge Tool

License Information

Make a Local Backup of VSys One in Another Folder

Photo Resize Tool

Purge Old Trace Records

Index Update Tool

Recalculate the Bonus Hours for Volunteer Hours

Recalculate the Value of Volunteer Hours

Restore From a Backup

Special Table Tools

SQL Commands to Database