Oracle creates tablespaces and users and assigns Permissions

Create a tablespace in oracle and assign permissions to users -- create a temporary tablespace create temporary tablespace data_temp tempfile 'd: \ oracle \ oraudata \ data_temp.dbf 'size 2000 m autoextend on next 500 m extent management local; www.2cto.com -- create tablespace data_data logging datafile 'd: \ oracle \ oraudata \ data_data.dbf 'size 2000 m autoextend on next 500 m extent management local; -- create a user and specify the tablespace create user dbadmin identified by dbpass default tablespace data_data temporary tablespace data_temp; -- delete the user command -- drop user dbadmin cascade -- grant the user permission to grant connect, resource to dbadmin -- revoke permission -- revoke connect, resource from dbadmin [/color]