Oracle creates table spaces, users, and permissions configuration

Oracle database and MySQL, SQL Server, it is in the same database can be defined multiple table space, the different table spaces are independent of each other, each user has a default table space, so basically different user operation of the data table can be different, Of course, if you want the same, you can set the table space when you define the table space.

To create a table space:

Create tablespace (your table space name is like PFM) datafile ' D:\oracle\product\10.2.0\oradata\orcl\pfm.dbf ' size 100Mautoextend on next 32M maxsize 200M extent management local;

To create a temporary tablespace:

Create temporary tablespace (your tablespace name is like PFM) tempfile ' D:\oracle\product\10.2.0\oradata\orcl\pfm.dbf ' size 100Mautoextend on next 32M maxsize 200M extent management local;

Create a new user and define a default tablespace:

Create user (the username you want to define) identified by (your password) default tablespace (the tablespace you want to define) temporary tablespace (your temporary tablespace);

To configure user permissions:

Grant CONNECT,RESOURCE,DBA to (user name);

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle creates table spaces, users, and permissions configuration