-- 创建数据库 create database localdb; -- 创建用户 create role lifuq with login encrypted password 'Mdasil789!@#'; -- 创建模式 create schema terminal_info; -- 赋予权限 grant all on schema terminal_info to lifuq; grant create on schema terminal_info to lifuq; grant usage on schema terminal_info to lifuq;