diff options
Diffstat (limited to 'standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql')
-rw-r--r-- | standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql new file mode 100644 index 00000000..49e9e593 --- /dev/null +++ b/standalone/src/main/assembly/resources/dbscripts/postgres/uui_create_db.sql @@ -0,0 +1,26 @@ +-- +-- Copyright (C) 2019 CMCC, Inc. and others. All rights reserved. +-- +-- Licensed under the Apache License, Version 2.0 (the "License"); +-- you may not use this file except in compliance with the License. +-- You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. +-- + +-- create uui user +create user "uui" with password 'uui' nocreatedb; + +-- create uui database +drop database if exists uui; +create database uui with owner uui template template0 encoding 'UTF8'; + +-- grant uui create uui user +grant all privileges on database uui to uui; +grant all privileges on database uui to postgres; |