G
G
gmg2016-09-18 19:44:53
PostgreSQL
gmg, 2016-09-18 19:44:53

How to create a user in postgreSQL so that he does not see other databases, other users?

Good afternoon!
How to create a user in postgreSQL so that he does not see other databases, other users?
I do it in the standard way:

postgres=# CREATE DATABASE test_database;
CREATE DATABASE

postgres=# CREATE USER test_user WITH password 'qwerty';
CREATE ROLE

postgres=# GRANT ALL privileges ON DATABASE test_database TO test_user;
GRANT

But through this user all other tables are visible. What did I screw up?
Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Denis, 2016-09-22
@ttys

here is a good example
, but in general here you can look for
an example in the TS one to one with eax.me =)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question