Postsqlgrant permission role

Postsqlgrant permission role spent a whole set of ipvs on his computer over the weekend. The depressing thing is: Use your own user tad, you can log on, you can view, however, you cannot use this operating system to access the table whose database owner is ipvs! For more information, see www.2cto. compsql-Upostgres to create a user:

Postsql grant permission role spent a whole set of ipvs on his computer over the weekend. The depressing thing is: Use your own user tad, you can log on, you can view, however, you cannot use this operating system to access the table whose database owner is ipvs! For more information, see www.2cto.com psql-U postgres. Create a user:

Postsql grant permission role

During the weekend, I spent a whole period of time on my computer. What was depressing was that I used my own user tad to log on and view it, however, you cannot use this operating system to access the table whose database owner is ipvs!

Continue to sort out and find www.2cto.com.

Psql-U postgres

Create a user:

Create role tad login password 'tad ';

Create user tad PASSWORD 'tad ';

PostgreSQL pre-defines many different types of built-in permissions, such as SELECT, INSERT, UPDATE, DELETE, RULE, REFERENCES, TRIGGER, CREATE, TEMPORARY, EXECUTE, and USAGE.

Assign permissions to a single table to tad: www.2cto.com

Grant ALL on table to tad; (all stands for ALL permissions, once and for all );

Then, the key is to check the tad user's permission to use ipvs,

Grant the ipvs user the following permissions:

Grant ipvs to tad;