0
I created a user in postgres so that a certain employee can run only one view available in the bank. I used the following query s:
CREATE ROLE LOGIN_FUNCIONARIO WITH LOGIN PASSWORD '999999' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION VALID UNTIL 'Infinity';
GRANT CONNECT ON DATABASE somefact TO login_funcionario ; GRANT USAGE ON SCHEMA producao TO login_funcionario ; GRANT SELECT on vw_controle_stock TO login_funcionario ;
When testing the access via Dbeaver or Pgadmin4, the user can only query the created view. Even though the user cannot perform any query or other type of operation in the other objects of the database, he is able to "see" the structure (columns, indexes, functions and etc.) of all tables in all schemes of the database, there is some way to also prohibit the user from viewing this information?
