Oracle databases allocate table space, create users, and assign User Permissions

The oracle Database allocates table space, creates users, and assigns user permissions. Operation 1. creates a temporary tablespace.
/* Create temporary tablespace */create temporary tablespace student_temp tempfile 'd: \ oracle \ product \ 10.2.0 \ oradata \ Student \ student_temp.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; www.2cto.com 2. Create a data table space
/* Create data tablespace */create tablespace student_data logging datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ Student \ student_data.dbf 'size 50 m autoextend on next 50 m maxsize 20480 m extent management local; www.2cto.com 3. Create a user and assign Permissions
/* Create user and distribute tablespace */create user student identified by cxhuan default tablespace student_data temporary tablespace student_temp; 4. Authorize the user
/* Authorize role to user */grant connect, resource, dba to student; Author: chengEmerson