Type | Requirement/Restriction |
---|---|
Primary Indexes and Primary Keys | The primary index and primary key for a table cannot contain a security constraint column. |
Secondary Indexes | Both unique and non-unique secondary indexes can contain one or more security constraint columns, but it is not required. |
Hash Indexes and Join Indexes | Join and hash indexes can reference only a single row level security base table, and only if the index definition contains all constraint columns in the table. Recommended action: Replace affected single-table hash and join indexes to include security constraint columns. |
Table Partitioning | A table partitioning expression cannot contain a security constraint column. |