PostgreSQL Database Basics

Create a read-only account

1.1 Log in with an initial account

[Email protected] ~]# psql-u Postgres

1.2 Creating a user

postgres=# Create role develop with login password ' 123456 ';

CREATE ROLE

postgres=# select Usename from Pg_user;

Usename

----------

Postgres

Test

Develop

(3 rows)

1.3 Switching databases

\c current_product

1.4 Granting read-only permissions

current_product=# Grant Select on all tables in the schema public to develop;

GRANT

1.5 Switch to develop user

current_product=# \c-develop

Connected to Database "Current_product" as user "develop".

1.6 Detecting whether read-only permission is granted

Current_product=> select * from test;

Id

----

(0 rows)

This article is from the "Youth Deng Yong" blog, please be sure to keep this source http://dengyong.blog.51cto.com/8409869/1888850

PostgreSQL Database Basics