SECURED

Description

Identifies a security label that exists for the security policy that is associated with the table.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10) COLUMN SECURED WITH securityLabel,
COL2 VARCHAR(10) COLUMN SECURED WITH securityLabel
);

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10)
) WITH ROW ACCESS POLICY securityLabel ON (COL1, COL2);

Known issues

If multiple security labels are declared an MSCEWI5001 will appear in the Snowflake output code as shown below

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10) COLUMN SECURED WITH securityLabel1,
COL2 VARCHAR(10) COLUMN SECURED WITH securityLabel2
)

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
COL2 VARCHAR(10)
) WITH ROW ACCESS POLICY securityLabel1 ON (COL1)
-- ** MSC-WARNING - MSCEWI5001 - WITH ROW ACCESS POLICY CLAUSE DOES NOT SUPPORT MULTIPLE DECLARATION IN SNOWFLAKE **
--                                                  WITH ROW ACCESS POLICY securityLabel2 ON (COL2)
                                                                                                 ;

Related EWIs

1. MSCEWI5001 Multiple Row Access policies