Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2808
  • Last Modified:

new schema in oracle9i

hi experts
I'm new in oracle 9i i would like to create a new schema to be viewed as "sys schema" under the database
How could i do  taht ?
thanks for your help
0
A_najem
Asked:
A_najem
1 Solution
 
NicksonKohCommented:
You cannot create a "sys" schema. sys account are special oracle accounts that are automatically created when the database is created. It's something like a windows administrator account except that this is for the oracle database.
0
 
A_najemAuthor Commented:

Hi

I want to see a new schema to create tables and views within  as same as any schema created with setting up oracle9i.
when I open the database many schema viewed. like system, sys, public, scott.....
i can not make a new schema be viewed in the same place?



0
 
NicksonKohCommented:
A schema is like a user space. You cannot create a schema within another schema. To create a new schema is simply to create a new user.

Create user test1 identified by test1;

To allow the user to be able to login, you can grant the minimum rights of

Grant create session to test1;

Nickson
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
A_najemAuthor Commented:
users are created under the security + users.
any suggest for a tutorial?

0
 
NicksonKohCommented:
You can do it from the SQL Plus (an SQL command line tool) or a GUI tool like the Enterprise Console which is like u said from security > users.

Sorry, I do not of any tutorial link. Learning oracle is quite a huge subject. If you looking to just add the user, try reading the online help.

Nickson

0
 
schwertnerCommented:
Start SQL*Plus and connect as user SYS:

SQL>connect sys/manager@some_instance as sysdba

First create tablespaces for the user:

CREATE TABLESPACE "NHIFD" DATAFILE '/u02/oradata/o10d/nhifd00.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 32767M LOGGING
 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
 

CREATE TABLESPACE "NHIFI" DATAFILE '/u02/oradata/o10d/nhifi00.dbf'
SIZE 25M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE 32767M LOGGING
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

CREATE TEMPORARY TABLESPACE "NHIFTEMP" TEMPFILE '/u02/oradata/o10d/nhiftemp01.dbf'
SIZE 97M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024K;

after that create the user:

DROP USER nhif CASCADE;

CREATE USER nhif IDENTIFIED BY nhif
DEFAULT TABLESPACE NHIFD  TEMPORARY TABLESPACE NHIFTEMP;
ALTER USER nhif QUOTA UNLIMITED ON NHIFD;
ALTER USER nhif QUOTA UNLIMITED ON NHIFI;
ALTER USER nhif QUOTA 0 ON USERS;

Grant some privileges:

GRANT create procedure, create session,create table,create type,create view,create synonym TO nhif;
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now