-- USER SQL
CREATE USER C##SBD_CB IDENTIFIED BY "sbd.2023" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;
--CREATE USER C##SBD_CB IDENTIFIED BY "sbd.2023" DEFAULT TABLESPACE "STUDENT" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK;

-- QUOTAS
ALTER USER C##SBD_CB QUOTA UNLIMITED ON USERS;

-- ROLES
GRANT "CONNECT" TO C##SBD_CB;

-- SYSTEM PRIVILEGES
--GRANT CREATE TABLESPACE TO C##SBD_CB;
GRANT CREATE SESSION TO C##SBD_CB;
GRANT CREATE TABLE TO C##SBD_CB; 
GRANT CREATE VIEW TO C##SBD_CB;
GRANT CREATE SEQUENCE TO C##SBD_CB;
GRANT CREATE SYNONYM TO C##SBD_CB
GRANT UNLIMITED TABLESPACE TO C##SBD_CB;
GRANT CREATE PROCEDURE TO C##SBD_CB;
GRANT CREATE TRIGGER TO C##SBD_CB;
GRANT CREATE TYPE TO C##SBD_CB;
                                
                            

Paste Hosted With By Wklejamy.pl