Error in epas 16 doc? - "Selecting SQL statements to audit"
Closed this issue · 2 comments
dbwagoner commented
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?
Expected behavior
No response
Screenshots
Browser / Platform
No response
Additional notes
No response
dbwagoner commented
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!
dbwagoner commented
Non-issue