| Scroll ignore | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||
This page will guide you through the setup of Postgres in K using the direct connect method.
...
| Info |
|---|
Note that visibility of entries in the pg_catalog 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. |
...
GRANT |
...
SELECT |
...
ON |
...
ALL |
...
TABLES |
...
IN |
...
SCHEMA |
...
<schema> |
...
TO |
...
<kada |
...
user> |
...
ALTER |
...
DEFAULT |
...
PRIVILEGES |
...
IN |
...
SCHEMA |
...
<schema> |
...
public |
...
GRANT |
...
SELECT |
...
ON |
...
TABLES |
...
TO |
...
<kada |
...
user> |
...
Step 2) Connecting K to Postgres
...