Siebel - Create Siebel Database User

Create SADMIN users and their role:

create role sse_role;
grant create session to sse_role;

create role tblo_role;
grant ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE INDEXTYPE,
  CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE SESSION,
  CREATE SYNONYM, CREATE TABLE, CREATE TRIGGER, CREATE TYPE, CREATE VIEW,
  CREATE DIMENSION, CREATE MATERIALIZED VIEW, QUERY REWRITE, ON COMMIT REFRESH
to tblo_role;

********* this should be not required **********
create user SIEBEL identified by SIEBEL;
grant tblo_role to SIEBEL;
grant sse_role to SIEBEL;
alter user SIEBEL quota 0 on SYSTEM quota 0 on SYSAUX;
alter user SIEBEL default tablespace &&siebel_tablespace;
alter user SIEBEL temporary tablespace &&temp_tablespace;
alter user SIEBEL quota unlimited on &&siebel_tablespace;
***************************************************

create user SADMIN identified by SADMIN;
grant sse_role to SADMIN;
alter user SADMIN default tablespace &&siebel_tablespace;
alter user SADMIN temporary tablespace &&temp_tablespace;

create user LDAPUSER identified by LDAPUSER;
grant sse_role to LDAPUSER;
alter user LDAPUSER default tablespace &&siebel_tablespace;
alter user LDAPUSER temporary tablespace &&temp_tablespace;

Create a readonly user

SQL> create user ABC identified by ___________;
SQL> GRANT create session, select any dictionary, select any table to ABC;