Below is the query to create user for Siebel Application with SQL Query in Oracle SQL Developer
create user <username> identified by "<password>";
grant <privilege> to <user>
CREATE USER "ATIF" IDENTIFIED BY "ATIF";
GRANT SSE_ROLE TO "ATIF";
Commit and all done.