AppFlowy-IO / AppFlowy-IO/AppFlowy-Supabase

Insecure Default Configuration

Ouverte
#16 0 commentaires 0 réactions 0 personnes assignées Voir sur GitHub
Langage dominant
Rust
Étoiles
10
Forks
11
Métriques de merge des PR
Aucune PR mergée en 30 j

Description

Hi there,

if one runs the [default migration](https://github.com/AppFlowy-IO/AppFlowy-Supabase/tree/main/postgres) security warnings pop up in supabase. These security warnings are related to [Row-Level-Security](https://supabase.com/docs/guides/database/database-advisors?queryGroups=lint&lint=0013_rls_disabled_in_public) and the [Security Definer View](https://supabase.com/docs/guides/database/database-advisors?queryGroups=lint&lint=0010_security_definer_view).

As a developer, I would like to have a migration which avoids these errors in the first place, so it is easier to have a safe supabase environment without the manual effort which is necessary now.

I am not 100% sure, but I think some steps to achieve this would be:

RLS
1. Enable RLS on all tables
2. Determine which tables need anonymous access (and which level of access specifically)
3. Create policies for those

Security Definer View
(I am not sure about this yet)

Guide de contribution

Aucun guide de contribution indexé pour ce dépôt

Évaluation

Cette issue n'a pas encore été évaluée.

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.