MyNixOS website logo
option

services.postgresql.ensureUsers.*.ensurePermissions

Permissions to ensure for the user, specified as an attribute set. The attribute names specify the database and tables to grant the permissions for. The attribute values specify the permissions to grant. You may specify one or multiple comma-separated SQL privileges here.

For more information on how to specify the target and on which privileges exist, see the GRANT syntax. The attributes are used as GRANT ${attrValue} ON ${attrName}.

Declarations
    Type
    attribute set of string
    Default
    { }
    Example
    {
      "DATABASE \"nextcloud\"" = "ALL PRIVILEGES";
      "ALL TABLES IN SCHEMA public" = "ALL PRIVILEGES";
    }