Role creation for top-level oracle users

Top-level users:

Username: SYS

Link: sysdba

Role creation:

/* Create the Customs V2.0 configuration library */drop tablespace cms_para including contents and datafiles; Create tablespace cms_para logging datafile 'd: \ oracle \ oradata \ orcl \ cms_para.ora 'size 5 m -- Oracle installation path reuse autoextend on next 1024 K maxsize 32767 M extent management local segment space management auto; /* Create the Customs V2.0 configuration Library User */drop user cms_para; create user cms_para profile "default" identified by "dcjet" default tablespace "cms_para" temporary tablespace "Temp" account unlock; grant connect to cms_para; grant DBA to cms_para; Alter user "cms_para" default role all;/* Create a customs V2.0 V2.0 V2.0 business database */drop tablespace cms_bus including contents and datafiles; create tablespace cms_bus logging datafile 'd: \ oracle \ oradata \ orcl \ cms_bus.ora 'size 5 m reuse autoextend on next 1024 K maxsize 32767 M extent management local segment space management auto; /* Create a Customs Service V2.0 V2.0 Business Database User */drop user cms_bus; create user cms_bus profile "default" identified by "dcjet" default tablespace "cms_bus" temporary tablespace "Temp" account unlock; grant connect to cms_bus; grant DBA to cms_bus; Alter user "cms_bus" default role all;