To create the audit database on Netezza, you have to enable certain security features, which at this version does not appear in the documentation.
I have the issue that ROW_SECURITY was not implemented. Here’s the file to edit and what to change.
cd /nz/data.
vi postgresql.conf
Change the entries for security from:
#
# Security Feature Control
#
# Disabled by default. Uncomment to enable
#
#enable_login_constraints = true
#enable_collect_history = true
#enable_row_security = true
#enable_audit = true
to
#
# Security Feature Control
#
# Disabled by default. Uncomment to enable
#
enable_login_constraints = true
enable_collect_history = true
enable_row_security = true
enable_audit = true
Now restart the database.
nzstop
nzstart
Now you should be able to proceed with ROW_SECURITY enabled.
