Versions Compared

Old Version 2

changes.mady.by.user eric revollo

Saved on

compared with

New Version Current

changes.mady.by.user eric revollo

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Run the following script to create a user...
    Code Block
    CREATE USER "testuser" WITH LOGIN PASSWORD 'testpass';
  2. Run the following script to grant database access to the user...
    Code Block
    GRANT CONNECT ON DATABASE "databaseName" TO "testuser";
  3. 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
titleNote

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.

...