Basic Administrative SQL commands - Revision history

Ppapa at 22:33, 3 January 2017

2017-01-03T22:33:45Z

Ppapa at 03:35, 11 January 2012

2012-01-11T03:35:56Z

Ppapa: /* Create a user */

2012-01-11T03:13:48Z

‎Create a user

Ppapa at 03:05, 11 January 2012

2012-01-11T03:05:02Z

Ppapa: Created page with "== Create tablespace == create tablespace '''''tablespacename''''' datafile ''''/''path''/''to''/''file''/''filename''.dbf'''' size 10m autoextend on next 5m maxsize ..."

2012-01-11T02:56:10Z

Created page with "== Create tablespace == create tablespace '''''tablespacename''''' datafile ''''/''path''/''to''/''file''/''filename''.dbf'''' size 10m autoextend on next 5m maxsize ..."

New page

== Create tablespace ==

create tablespace '''''tablespacename'''''
datafile ''''/''path''/''to''/''file''/''filename''.dbf''''
size 10m autoextend on
next 5m maxsize 1G;

This will create a 20mb datafile that will extend by 5mb until it gets to 1gb max.

== Add datafile to tablespace ==

alter tablespace '''''tablespacename'''''
add datafile ''''/''path''/''to''/''file''/''filename''.dbf''''
size 10m autoextend on
next 5m maxsize 1G;

@@ Line 6: / Line 6: @@
     next 5m maxsize 1G;
-This will create a 20mb datafile that will extend by 5mb until it gets to 1gb max.
+This will create a 10mb datafile that will extend by 5mb until it gets to 1gb max.
 == Add Datafile to Tablespace ==

@@ Line 8: / Line 8: @@
 This will create a 20mb datafile that will extend by 5mb until it gets to 1gb max.
-== Add datafile to tablespace ==
+== Add Datafile to Tablespace ==
    alter tablespace '''''tablespacename'''''
@@ Line 15: / Line 15: @@
     next 5m maxsize 1G;
-== Create a user ==
+You need to create a role that will give the users privileges to do things
 Create the account:
@@ Line 27: / Line 38: @@
     account unlock;
-Give the account priveleges:
+Give the account priveleges using the role you created before:
-   grant connect to '''''username''''';
+   grant '''''rolename''''' to '''''username''''';

@@ Line 17: / Line 17: @@
 == Create a user ==
    create user '''''username'''''
@@ Line 24: / Line 26: @@
     quota '''''unlimited''''' on '''''tablespacename'''''
     account unlock;

← Older revision		Revision as of 03:05, 11 January 2012
Line 14:		Line 14:
	size 10m autoextend on		size 10m autoextend on
	next 5m maxsize 1G;		next 5m maxsize 1G;
		+
		+
		+	== Create a user ==
		+
		+	create user '''''username'''''
		+	identified by '''''password'''''
		+	default tablespace '''''tablespacename'''''
		+	temporary tablespace '''''temp'''''
		+	quota '''''unlimited''''' on '''''tablespacename'''''
		+	account unlock;