|| ||      

---

Adding users to Oracle

This appendix shows how to add new users to Oracle with the capability to store segmentations. Enter SQL*Plus with system privileges (sys or oracle user) and execute the following statements:

SQL> CREATE USER newuser IDENTIFIED BY userpassw;

This creates a user named newuser with password userpassw.

SQL> GRANT VxUser, UNLIMITED TABLESPACE TO newuser;

This command grants to the new user the role VxUser (the user receives all the privileges granted to the role). This role contains the next system privileges:

• ALTER SESSION
• CREATE CLUSTER
• CREATE DATABASE LINK
• CREATE INDEXTYPE
• CREATE OPERATOR
• CREATE PROCEDURE
• CREATE SEQUENCE
• CREATE SESSION
• CREATE SYNONYM
• CREATE TABLE
• CREATE TRIGGER
• CREATE TYPE
• CREATE VIEW

The UNLIMITED TABLESPACE privilege is also granted to the user. This privilege allows to use space in all the tablespaces (the default tablespace is SYSTEM). No limit is specified.

To specify a disk quota use the following commands:

SQL> REVOKE UNLIMITED TABLESPACE FROM newuser;
SQL> ALTER USER newuser QUOTA 5M ON system;

Once the user is created, he has to create the tables to store segmentations: VxSegmentation_tab, VxSegment_tab, VxSegmentStringFeature_tab, VxSegmentIntFeature_tab and VxSegmentDoubleFeature_tab. The sequences VxSegmentation_id and VxSegment_id also need to be created.

You can do it with the CREATE statements shown in this documentation or through the makeTables script:

SQL> START makeTables.sql

---

Go to the next section or return to the index.

---