terminal_info/doc/部署文档/10.170.42.93_部署/sql脚本/创建数据库、模式和用户.sql

-- 创建数据库
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;