pgsql 数据库添加权限

以超级用户身份连接

./psql -U postgres -d dotest



-- 授予 public 模式的所有权限
GRANT ALL ON SCHEMA public TO dotest;

-- 授予在 public 模式中创建对象的权限
GRANT CREATE ON SCHEMA public TO dotest;

-- 授予现有表的权限
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO dotest;

-- 设置默认权限
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO dotest;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO dotest;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON FUNCTIONS TO dotest;