Why did all my tables disappear after changing the user? I created a new user and granted all privileges, but my database is empty after I log in with this new user ? If I log in with the original user they all come back, but I need to work with the tables with the new created user. I know I can re-create them, but I would like to have them without doing this.

CodePudding user response：

In the connections tab, expand the connection and go to "Other Users" at the bottom of the list and you will see the list of users and, expanding those, their tables (and other objects) that you have at least the SELECT privilege on.

If you want to refer to tables owned by another user in a query then specify the schema name as well as the table name:

SELECT *
FROM   other_schema.table_name;