Create a tablespace in Oracle and grant permissions

Create a tablespace in Oracle and grant permissions

SQL>
Create tablespace stu_data
Datafile 'e: \ G3T05 \ oracle \ t1 \ stu_data.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;
 
Tablespace created
 
SQL>
SQL>
Create temporary tablespace stu_temp
Tempfile 'e: \ G3T05 \ oracle \ t1 \ stu_temp.dbf'
Size 50 m
Autoextend on
Next 50 m maxsize 20480 m
Extent management local;

 
SQL>
Create user tudou identified by "111"
Default tablespace stu_data
Temporary tablespace stu_temp;
 
User created
 
SQL> grant connect, resource to tudou;