RSTs and external tables
There are no row-secure external tables, as the Netezza Performance Server system does not apply row security filtering on external tables. The file contents are not secure, and anyone with file access can view the data. External tables can have string columns that contain label strings in the label column, and can be used to load and unload RSTs.
To capture the label with a SELECT statement, you must be explicit,
as in the following example:
DEV(ADMIN)=> CREATE TABLE rst (id int, name varchar(80), metric int)
ROW SECURITY;
CREATE TABLE
DEV(ADMIN)=> CREATE EXTERNAL TABLE 'TMP/XT’ AS SELECT *, _SEC_LABEL
FROM rst;
INSERT 0 0