Content Comparison

Note that visibility of entries in these tables will depend on if the user has SELECT access to the table, so make sure SELECT is granted to the <kada user> for all tables within the database. You may need to re-apply this grant if schemas are dropped, you may also wish to apply a default grant on the schema so future tables can be visible.

1. Code Block
   language sql
   GRANT SELECT ON ALL TABLES IN SCHEMA <schema> TO <kada user>user;user>

2. Code Block
   language sql
   ALTER DEFAULT PRIVILEGES IN SCHEMA <schema> public GRANT SELECT ON TABLES TO <kada user>;