🛢️ Database (JDBC)

Queries in this section will allow discovery of system and local accounts and their permissions to databases as well as a sample application database setup and queries that demonstrate managing accounts and permissions in a custom database.

It is a good practice to copy the SQL query and run the following command (Mac) before pasting them in Lumos JDBC Connector configuration.

pbpaste | tr '\n' ' ' | sed -e 's/[[:space:]]/ /g' | sed -e 's/ \{2,\}/ /g' | pbcopy

🚧

Note: Lumos does not support comments in SQL queries