Page History
...
- Run the following script to create a user...
Code Block CREATE USER "testuser" WITH LOGIN PASSWORD 'testpass';
- Run the following script to grant database access to the user...
Code Block GRANT CONNECT ON DATABASE "databaseName" TO "testuser";
- Run the following script to grant permissions to the above created user to access all the metadata tables...
Code Block GRANT ALL ON SCHEMA "wsmeta" TO "testuser";
GRANT ALL ON ALL TABLES IN SCHEMA "wsmeta" TO "testuser"
GRANT ALL ON ALL SEQUENCES IN SCHEMA "wsmeta" TO "testuser"
Note | ||
---|---|---|
| ||
If a repository has been upgraded, it is recommended to log back into the database and reapply the above queries for all users that can connect to the database. This is required to ensure there are no permission issues that will block the general usage of WhereScape3D. |
...