Restricting Access to Rows › Assigning Row-level Security to Data Tables › Assigning Row-level Security › Considerations

Considerations

When assigning security names to multiple tables, make sure the criteria apply only to the columns you intend them to. For example:

Distinguishing Columns

When two columns in different tables have the same name and you want to apply WHERE criteria to only one of the columns, do one of the following:

• Change the name of one of the columns, preventing the WHERE criteria from being applied to both columns.
• Change the security name of one table, so the WHERE criteria will not apply to both tables.
• Assign a generic column name to one of the tables. This changes the name of that column.

Grouping Columns

When two columns in different tables have different names and you want to use one SRT entry to apply the same WHERE criteria to both columns, assign a generic column name to the columns. When WHERE criteria are written using generic column names, the system regards the two columns as one and applies criteria to both. Generic column names must be alphanumeric character strings that do not contain hyphens or special characters.