Getting Started #
Although they are referred to as Tables, most users are actually using Views. Views are a layer on top of Tables where security can be applied. All secured datatypes in the VA Data Security Setup are still effective when users are downloading data using TAD.
If you’re using SQL Accounts to access TAD, make sure to assign the appropriate data security groups to the SQL Accounts in the VA User Profile in Vista.
Data Security #
If you have data security active, you must add the necessary Security Groups to the new account. Otherwise, the user will not be able to see any data when downloading in TAD.
On the Vista main menu, go to Viewpoint Administration → Programs → VA Data Security Setup.
Data security is active when the Secured checkbox is checked.
If data security is active, you need to add the data security groups to the new SQL Account on the VA User Profile → Security Groups tab.
If you have the bEmployee datatype secured, you can grant access by adding the SQL Account to the Group Security tab on the PR Groups form.
Has Data Security Been Applied?
The Secure Tables tab on VA Data Security Setup shows whether data security has been applied.
The Apply Security checkbox is used to identify which Table Names you want to apply security to.
If Not Synchronized is checked, it means the security has not been applied.
Click the Regenerate Views button to apply the security.
Click the Add Unsynchronized Views button.
The upper right list will populate with all Views that need to be regenerated.
Click the Regenerate Views button.
You will receive the message below indicating that the regeneration is complete.
You will see that the Secured checkbox is now checked, meaning security has been successfully applied.
