Adding Security to Tables and Columns
Security can be established in each database, although RMS and DBMS databases do not support column-level security. You can use CONNX to restrict the access of each user on column or table level.
1. Select a table or view from the list box in the CONNX Data Dictionary Manager window.
2. Click the Table Security or View Security tab in the lower pane, and then click the Add Restriction button.
3. To add a restriction to a table or view, select the name of the user or group to restrict in the User list box.
4. To add a restriction to a column, select the name of the column to which you want to restrict access in the SQL Column list box.
Select <All Columns> if the security entry is to apply to the entire table. Select <Everyone> and <All Columns> on all tables in order to maintain the highest levels of security.
5. Select the check boxes in the remaining columns to define access rights for each user or group as described in the following table.
Access | Definition |
Select | Read only - can run Select queries. |
Update | Can update queries and can modify existing data, but not add new data. |
Insert | Can insert new data. |
Delete | Can delete data. |
Drop | Can drop tables and keys to remove them completely. |
Execute | Can execute stored procedures. |
RFI | Can enable referential integrity. (Not available in this release.) |