PG数据库、用户操作

Thursday, Nov 28, 2024 | 1 minute read | Updated at Thursday, Nov 28, 2024

@
PG数据库、用户操作

Cut out summary from your post content here.

The remaining content of your post.

PG 数据库、用户相关

-- 创建数据库
CREATE DATABASE mydatabase;

-- 创建用户
CREATE USER myuser WITH PASSWORD 'mypassword';

-- 授予用户数据库的所有权限
GRANT ALL PRIVILEGES ON DATABASE mydatabase TO myuser;

-- 切换到目标数据库
\c mydatabase

-- 授予用户所有现有表的所有权限
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO myuser;

-- 授予用户对新表的默认权限
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL PRIVILEGES ON TABLES TO myuser;

-- 授予用户视图和序列的权限(可选)
GRANT ALL PRIVILEGES ON ALL VIEWS IN SCHEMA public TO myuser;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO myuser;

© 2016 - 2025 Caisong's Blog

🌱 Powered by Hugo with theme Dream.

About Me

大龄程序员,喜欢折腾各种环境部署、软件应用。

博客记录日常。