CREATE USER username PASSWORD 'password'; GRANT CONNECT ON DATABASE "database" TO username; GRANT ALL PRIVILEGES ON DATABASE "message-center" TO username; grant usage on schema public to username; grant all privileges on all tables in schema public to username; select * from "database".information_schema.table_privileges;
postgre sql 添加用户及赋权限
最新推荐文章于 2024-07-23 19:39:30 发布