Oracle create tablespace, user and grant

-- Create a tablespace
Create tablespace tablename datafile 'e: \ oracle \ dbname. dbf' size 1024 M autoextend on next 100 m maxsize unlimited;
Create smallfile temporary tablespace temptest tempfile 'e: \ oracle \ dbname2.dbf' size 100 m extent management local uniform size 1 m;

-- Create a user
Create User Username identified by "password" default tablespace tablename temporary tablespace tablename2 account unlock;

-- Authorization: Connection permission
Grant connect to username;

-- Authorization: All other Permissions
Grant resource to username;
Revoke connect from username