newdb.sql
· 912 B · MySQL
原始檔案
CREATE DATABASE spacebin;
DO $$
DECLARE
db_name text default 'spacebin';
username text default 'spacebin';
user_password text default '/Yg6OS+BJMj5rHFGhsf00A==';
BEGIN
EXECUTE format('CREATE USER %I WITH PASSWORD %L', username, user_password);
EXECUTE format('GRANT ALL PRIVILEGES ON DATABASE %I TO %I', db_name, username);
SET search_path TO db_name, public;
EXECUTE format('GRANT ALL PRIVILEGES ON SCHEMA public TO %I', username);
EXECUTE format('GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO %I', username);
EXECUTE format('GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO %I', username);
EXECUTE format('ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO %I', username);
EXECUTE format('ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO %I', username);
END $$;
grant all privileges on schema public to spacebin
| 1 | CREATE DATABASE spacebin; |
| 2 | DO $$ |
| 3 | DECLARE |
| 4 | db_name text default 'spacebin'; |
| 5 | username text default 'spacebin'; |
| 6 | user_password text default '/Yg6OS+BJMj5rHFGhsf00A=='; |
| 7 | BEGIN |
| 8 | EXECUTE format('CREATE USER %I WITH PASSWORD %L', username, user_password); |
| 9 | |
| 10 | EXECUTE format('GRANT ALL PRIVILEGES ON DATABASE %I TO %I', db_name, username); |
| 11 | SET search_path TO db_name, public; |
| 12 | |
| 13 | EXECUTE format('GRANT ALL PRIVILEGES ON SCHEMA public TO %I', username); |
| 14 | EXECUTE format('GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO %I', username); |
| 15 | EXECUTE format('GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO %I', username); |
| 16 | EXECUTE format('ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO %I', username); |
| 17 | EXECUTE format('ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO %I', username); |
| 18 | END $$; |
| 19 | |
| 20 | grant all privileges on schema public to spacebin |
| 21 |