-- Create a user named user1 with password 'secret'
-- Create a database named db1
-- Grant the user1 access to the database db1
 

CREATE USER user1 WITH PASSWORD 'secret'        -- create user/pswd
                                                -- inserts a new row in user table 

CREATE DATABASE db1;                            -- create a database
                                                -- at O/S, this creates a new folder

GRANT ALL ON DATABASE  db1  TO  user1;          -- grant all privliges, except for GRANT
                                                -- inserts a new row in db table