joaofabioma

create user owner to database

Aug 24th, 2026
50
0
Never
2
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 0.24 KB | Software | 0 0
  1. CREATE ROLE systemfatfituser WITH LOGIN PASSWORD 'systemfatfitpass' CREATEDB;
  2. CREATE DATABASE systemfatfitdb WITH OWNER systemfatfituser;
  3. GRANT ALL ON DATABASE systemfatfitdb TO systemfatfituser;
  4. GRANT ALL ON SCHEMA public TO pg_database_owner;
  5.  
Advertisement
Comments
  • User was banned
  • User was banned
Add Comment
Please, Sign In to add comment