create user as identified by password default tablespace ... temporary tablespace ...;grant connect,resource to aa;aa用户的默认表空间是users(你的oracle是9i以上),temp表空间默认是temp