Create User and table spaces

Oracle 11.2.0.1

1. Create a new user default tablespace Dcsopen_tbs:

Note :

(1) Setting the initial data file size here is the default auto-growth of the 200m,autoextend property, which allocates 32M each time a new tablespace is requested, allocating up to 1024M.

(2) The EXTENTMANAGEMENT LOCAL (optional) is not used here, but the default is the local administration mode (extent_management), which is assigned the zone size to Autoallocate ( Allocation_type is System), the segment space is managed as Auto Auto (segment_space_management).

2. Create a new temporal tablespace Dcsopen_temptbs:

Note :

(1) Temporary tablespace cannot use Auto's dimension allocation, and temporary tablespace is created ) Font-family:microsoft Yahei ">, can also be specified: Uniforma SIZE 2m

(2) follow Oracle's recommendation to use a locally managed temporary tablespace that uses the 1M uniform zone size as the default temporary table space.

3. Create User dcsopen:

Note :

(1) Specify the user default tablespace and default temporary tablespace, if not specified, the default tablespace uses the users table space that is typically created for Oracle, and the default temporary tablespace uses temp (if not built using the system tablespace ).

(2) You can then give the user permissions, for example:

grant
Create SESSION, create any TABLE, create any VIEW, create any INDEX, create Any PROCEDURE,
alter any table, alter any PROCEDURE,
drop any table, drop any VIEW, drop any INDEX, drop any PR Ocedure,
SELECT any table, INSERT any table, UPDATE any table, DELETE any table
to Dcsopen;

(3) here 10g and oneG seem to have some difference in the quota of the user using the table space.

Phenomenon:

(3.1)10g creates a new user with the users table space by default, giving only the CREATE table and CREATE table permissions, which the user uses the Create Table prompts when creating tables: Ora-01950:no privileges on tablespace ' USERS '

(3.2) 11g creates a new user, by default using the Users table space, gives only the CREATE table and create TABLE permissions, which can be created table.

Ordinarily the user has resource permissions to use the table space quotas, 11g for that user using revoke resource from R1; Prompt ora-01951:role ' RESOURCE ' not granted to ' R1 ', stating that the user does not have RESOURCE permissions.

Create User and table spaces