The Record Access report lists the users that are enabled or blocked using entity, project, property, or basis security in the selected database. When you run the Record Access report, it generates a single Microsoft Excel workbook. The workbook contains a worksheet for each table to which user restrictions have been applied. Each worksheet contains the following columns:
▪ Record ID
▪ Record description
The rest of the columns contain the users within the selected database who have security applied. The access for each user is indicated in each column as described below:
▪ F—Full access. The user or role can add, modify, and delete the record.
▪ V—View-only access. The user or role can access but not add, modify, or delete the record.
▪ Blank—No access. The user or role cannot access this records.
Note
You must have Report Access permissions to run this report. Refer to Adding and Maintaining Users and Access Rights for more information.
The Record Access report can only be run by user. It is not available to run by role.
To run the Record Access report, follow these steps:
1. Go to Reporting.
2. In the Report field, select Record Access Report.
3. In the Database field, select a database.
4. Click Run.
5. When the report has finished running, click Download Report. The report can also be downloaded later by clicking the Work Requests button in the upper-right corner of Security Console.