配置用戶訪問模式權限
更新時間 2025-02-14 10:21:48
最近更新時間: 2025-02-14 10:21:48
分享文章
您可以參考本文，配置用戶訪問模式權限。
普通用戶對于某個模式下的對象訪問除了訪問對象要授權外，模式也需要授權。
[teledb@localhost bin]$ ./telesql -p 11111 -U teledb -d teledb
Password for user teledb:
telesql (TeleDB V6)
Type "help" for help.
-- 創建shema
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)
