access without login

Hi,

is there a way to configure reports for which no login is needed upfront?

Hi @gpagomen. There is no way to access the list of queries or query editor without a login, but there is a way to allow them to be run without login.

To enable this feature go to the configuration page, and change Require Login for Table/Chart Links to false.

Once that is set you can send the table or chart link to someone or embed it in another view (url will be /query-table/:queryid or /query-chart/:queryid)

There were plans to implement a "view only" role and a no-login mode for sqlpad but I haven't had much time to work on it lately.

Thank you, first of all, @rickbergfalk for this awesome product! The only thing that I'm missing much is your anticipated "view only" role for users. That would be so awesome! In our company would fulfill the 100% of our needs :)

Is there a config parameter to do this on the docker image?

To enable this feature go to the configuration page, and change Require Login for Table/Chart Links to false.

What exactly do I have to do? I can't find anything about it in https://getsqlpad.com/#/configuration

Hi @ad-si - that functionality was removed in v5 https://github.com/sqlpad/sqlpad/blob/master/CHANGELOG.md#breaking

Authentication can be disabled via these env vars:

# Set to `true` to disable authentication altogether.
SQLPAD_AUTH_DISABLED = "false"
# Specifies the role associated with users when SQLPAD_AUTH_DISABLED is set to true.
# Acceptable values: `admin`, `editor`.
SQLPAD_AUTH_DISABLED_DEFAULT_ROLE = "editor"