Oracle Query.sql

-- Create user/schema
create user user_name identified by p@ssword;
-- Grant privileges
grant all privileges to user_name;
-- [[[Grant Privileges on Tables]]]
grant [privileges] on object_tables_views to user;
grant execute on object_procedures to user;
grant execute on object_procedures to public;
-- Example
grant select, insert, update, delete, references, alter, index on suppliers_obj to smithj_user;

-- OR
grant all on suppliers_obj to smithj_user;

-- [[[Revoke Privileges on Tables]]]
revoke privileges on object_tables_views from user;
revoke execute on object_procedures from user;
revoke execute on object_procedures from public;
-- Example
revoke select, insert, update, delete, references, alter, index on suppliers_obj from smithj_user;
revoke all on suppliers_obj from smithj_user;
revoke all on suppliers_obj from public;


-- Change password
alter user user_name identified by p@ssword;

-- Practice
create user crbt_peru identified by crbt_peru#2013;