Schema access denied of PostgreSQL

Sometimes, users may encounter access to schema... Denied and other error messages.

In Postgresql, data access permissions are divided into at least two levels.

One is schema and the other is table.

Therefore, for a common user test, if a Super User gives him the following permissions:

Grant all on schema01. Table01 to public;

At this time, log on to the test as a common user,

Test => select count (*) from schema01.Tabl01;

The error message is that the schema permission is insufficient.

The following operations can be accessed by the superuser:

S # Grant all on schema01 to public;

For example, schema is a door, and the access to table is a box key.

There is only an out-of-the-box key, and no door key. You cannot see what is in the box. You must open the door before entering the room to open the box.