schema_creation_scripts

CREATE USER SC_ORDS  IDENTIFIED BY MyPassword;
GRANT CONNECT TO SC_ORDS ;
GRANT CONNECT, RESOURCE, DBA TO SC_ORDS ;
GRANT CREATE SESSION SC_ORDS ;
GRANT ANY PRIVILEGE TO SC_ORDSSC_ORDS ;
GRANT UNLIMITED TABLESPACE TO books_admin;


GRANT
  SELECT,
  INSERT,
  UPDATE,
  DELETE
ON
  schema.books
TO
  SC_ORDS ;


create user SCCONSOLE identified by ShipC0nsol3;
grant connect, resource to SCCONSOLE;
grant create table to SCCONSOLE;
grant unlimited tablespace to SCCONSOLE;


-- USER SQL
ALTER USER "SCCONSOLE"
DEFAULT TABLESPACE "SCCONSOLE_DATA"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK ;

-- QUOTAS

-- ROLES
ALTER USER "SCCONSOLE" DEFAULT ROLE "CONNECT","RESOURCE";

-- SYSTEM PRIVILEGES