I am still picking up skill on postgres and have received a specific requirement.
Create database : DB
Create user: USERA
Schema : SCHEMAC
User USERA should have all the access to create objects/execute in its own schema.
1. I have created database DB with owner as DB(created one user as DB).
2. created user USERA using $createuser command, with role as USERA, no create database/super users etc are not given 3. Created Schema as - command -"Create schema SCHEMAC authorization USERA"
But objects are getting created in public, I understand by default its the feature and is looking for assistance in how can I redirect to SCHEMAC.