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: 2535
  • Last Modified:

Creating Users in Oracle9i

Hi,

Please give me the syntax of creating Users in Oracle9i.

And also please refer me with some URL where i can get
good docs related to Oracle DBA

Thanks & Regards
Suresh
0
sureshk_oracle
Asked:
sureshk_oracle
1 Solution
 
Ivan_SkrinjaricCommented:
Hi,

the syntax is:

CREATE USER username
      IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS external_name}
         options

options:
   
   DEFAULT TABLESPACE tablespace_name
   TEMPORARY TABLESPACE tablespace_name
   QUOTA int {K | M} ON tablespace_name
   QUOTA UNLIMITED ON tablespace_name
   PROFILE profile_name
   PASSWORD EXPIRE
   ACCOUNT {LOCK|UNLOCK}

EXAMPLES

-- Create a user with no rights to save data or create objects:

CREATE USER limited IDENTIFIED BY ChangeThis


-- Create a user with full rights to create objects and save data:

DROP USER MySchemaOwner CASCADE;

CREATE USER MySchemaOwner IDENTIFIED BY ChangeThis
       DEFAULT TABLESPACE data  
       TEMPORARY TABLESPACE temp
       QUOTA UNLIMITED ON data;

GRANT CREATE procedure, CREATE session,
      CREATE table, CREATE view,
      CREATE synonym TO MySchemaOwner;


The link to complete oracle documentation is:

http://otn.oracle.com/documentation/oracle9i_arch_901.html

To browse documentation requires creating account which is free.
0
 
vr_balaCommented:
You can information about general oracle dba in the following links also.

1) metalink.oracle.com ( you need userid/password )
2) asktom.oracle.com
3) devtrends.oracle.com
4) www.orakle.com ( Oracle related links )
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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