Check table permissions using the Table Permissions Report (RPTABLE)
Use the Table Permissions Report (RPTABLE) report to generate a listing of the table permissions that you assign using the User Permission Wizard (PERMWIZ) page.
To generate the table permission report
-
Open the Table Permissions Report (RPTABLE) page.
- Select Utilities > Utility Reports > Table Permissions Report.
Or
- Search for RPTABLE or Table Permissions Report in the Navigation box and then select Table Permissions Report.
Table Permissions Report (RPTABLE) page appears.
-
In the Sort Order list, select:
-
User, Company, Table: To view the assigned table permissions of each user ordered by the user name, company number, and the table name.
-
Screen: To view the assigned table permissions of each user ordered by the page name.
The user inherits the table permissions assigned to the groups that the user belongs to.
-
-
In the Sort Range list, specify the sort range.
TheSort On field is populated based on the type of report selected in the Selection list.
The available sort ranges are:
-
Single: Select this option to include only one item. Selecting this option enables the From field. Do one of the following:
-
Type the item reference in the From field.
-
Click the Lookup Reference and from the Lookup For From window, select the required sort item, and click Select.
-
-
Range: Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:
-
Type the first and last values of the range in the From and To fields.
-
Click the Lookup Reference (if available) and from the Lookup For window, select the required sort item, and click Select.
-
-
All: Select this to include all available items.
-
-
To generate a company-specific report if required, in the Other Variables section, in the Company (Optional) field, type the company number.
-
On the Toolbar, click Run Report to generate the report.
Select Open now to open the report in a new tab or select Notify when Complete to get notification. You can open the downloaded report from My Reports page.
Made2Manage displays a check mark under the report’s permission column, if you’ve assigned the permission.