-- Create a user named user1 with password secret -----------------

create user user1 identified by secret
       default tablespace CLASS_DATA
       temporary tablespace TEMP
       quota 5M on CLASS_DATA;
       

-- Grant privliges to user1  -----------------------------

grant connect  to user1;		            -- connect to session       
grant resource to user1;		            -- DML, DDL (except for GRANT)       
grant create view      to user1;	        -- create view       
grant create procedure to user1;	        -- create function/procedure       
grant select any dictionary to user1;	    -- access to data dictionary       


-- commit all changes --------------------

commit;