EnterpriseDB/docs

Error in epas 16 doc? - "Selecting SQL statements to audit"

Closed this issue · 2 comments

Summary

In the code sample that shows "ALTER ROLE adminuser WITH LOGIN," there is a syntax error. The incorrect command and the error are shown in the code box. Then the corrected command follows (without commas). It appears to me that someone inadvertently included the incorrect command and error message, since it does not appear to be included for instructional purposes.

Here is the code snippet:

edb=# CREATE ROLE adminuser;
CREATE ROLE
edb=# **ALTER ROLE adminuser WITH LOGIN, SUPERUSER, PASSWORD 'password';
ERROR:  syntax error at or near ","
LINE 1: ALTER ROLE adminuser WITH LOGIN, SUPERUSER, PASSWORD 'passwo...
                                    ^**
edb=# ALTER ROLE adminuser WITH LOGIN SUPERUSER PASSWORD 'password';
ALTER ROLE

Where did you see the problem?

https://github.com/EnterpriseDB/docs/blob/content/docs/epas/v16_branch/product_docs/docs/epas/16/epas_security_guide/05_edb_audit_logging/02_selecting_sql_statements_to_audit.mdx

Expected behavior

No response

Screenshots

image

Browser / Platform

No response

Additional notes

No response

Nevermind, this was an instructional example of the error message being logged via auditing. Please close this as a non-issue. Time to stop working for the weekend!

Non-issue