create a database user in oracle express edition 11g R2 11gb

goto command prompt
type sqlplus
  • Enter user-name: system
  • Enter password: <password-for-system>
Create the user. For example, enter a statement in the following form:
SQL> create user chris identified by <password-for-chris>;
Grant the user the necessary privileges. For example:
SQL> grant CREATE SESSION, ALTER SESSION, CREATE DATABASE LINK, -
  CREATE MATERIALIZED VIEW, CREATE PROCEDURE, CREATE PUBLIC SYNONYM, -
  CREATE ROLE, CREATE SEQUENCE, CREATE SYNONYM, CREATE TABLE, - 
  CREATE TRIGGER, CREATE TYPE, CREATE VIEW, UNLIMITED TABLESPACE -
  to chris;
Optionally, exit SQL*Plus (which also closes the command window):
SQL> exit

Comments

Popular posts from this blog

storing byte array as column value in datatable using c#

post form data and bind with model : using jquery ajax in mvc

Htc sensation XL mobile not working with windows 7 or above, along with Htc sync software