oracle创建新用户和表空间

oracle创建新用户和表空间
create user c##test identified by 123456;
grant create user,drop user,alter user,create any view,connect,resource,dba,create session,create any sequence to c##test ;