Learn SOA

How to build an XSD?
Watch the below youtube video for learning how to build an xsd using JDeveloper (11g)

https://www.youtube.com/watch?v=250pkV5F400

https://www.youtube.com/watch?v=o62ST-82cM0

--Connect as System user

CONNECT <USER-NAME>/<PASSWORD>@<DATABASE NAME>;

 

--Create user query

CREATE USER <USER NAME> IDENTIFIED BY <PASSWORD>;

 

--Provide roles

GRANT CONNECT,RESOURCE,DBA TO <USER NAME>;

 

--Provide privileges

GRANT CREATE SESSION TO <USER NAME>;

 

GRANT UNLIMITED TABLESPACE TO <USER NAME>;

 

--Provide access to tables.

GRANT SELECT,UPDATE,INSERT ON <TABLE NAME> TO <USER NAME>;