配置用戶訪問模式權限
更新時間 2025-02-05 09:36:26
最近更新時間: 2025-02-05 09:36:26
分享文章
您可以參考本文，配置用戶訪問模式權限。
當普通用戶訪問某個模式下的對象時，需要對對象授權，也需要對模式授權。
[teledb@localhost bin]$ ./telesql -p 11111 -U teledb -d teledb
Password for user teledb:
telesql (TeleDB V6)
Type "help" for help.
- 創建schema
teledb=# create schema test; CREATE SCHEMA - 創建表
teledb=# create table test.t1(id int); CREATE TABLE - 創建用戶user1
teledb=# create role user1 with login password 'User@184'; CREATE ROLE - 給用戶user1授權表訪問權限
teledb=# grant select on test.t1 to user1; GRANT
示例：
- 切換至普通用戶user1，嘗試訪問test.t1表。由于沒有授權test模式，仍然無法訪問。
teledb=# \c - user1 Password for user user1: You are now connected to database "teledb" as user "user1". teledb=> select * from test.t1; ERROR: permission denied for schema test LINE 1: select * from test.t1; ^ - 切換至teledb用戶，將test模式的訪問權限授權給user1，重新用user1訪問t1表。
teledb=> \c - teledb Password for user teledb: You are now connected to database "teledb" as user "teledb". -- 授權schema teledb=# grant usage on schema test to user1; GRANT teledb=# \c - user1 Password for user user1: You are now connected to database "teledb" as user "user1". teledb=> select * from test.t1; id ---- (0 rows)
