{
"title":"Configure Oracle",
"text":"This Tutorial steps you through setting up your Oracle Cloud account and your Oracle Autonomous Database",
"pages":[
{ "title":"Creating an Oracle Autonomous Database",
"text":"
","title":"Configure Oracle",
"text":"This Tutorial steps you through setting up your Oracle Cloud account and your Oracle Autonomous Database",
"pages":[
{ "title":"Creating an Oracle Autonomous Database",
"text":"
\r\nIn this video we will see how to create an Oracle Cloud Account and create an Autonomous Database\r\n
\r\n\r\n\r\n\r\n\r\n \r\n
\r\n \r\n
\r\n\r\nURL to Sign Up
\r\ncontent_copy
https://signup.cloud.oracle.com
\r\n \r\n
\r\nSQL Statements
\r\ncontent_copy
create table author(\r\n author_id int primary key,\r\n first_name varchar(50),\r\n last_name varchar(50)\r\n);\r\n\r\ninsert into author values(100,'Theodor', 'Geisel');\r\ninsert into author values(101,'Harriet', 'Stowe');\r\ninsert into author values(102,'Jane', 'Austen');\r\n\r\n\r\nselect * from author;\r\n
"scripts":[]
},
{ "title":"Creating Oracle User Accounts",
"text":"
\r\nIn this video, we will see how to create a general purpose user for our Oracle Autonomous Database.\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n
",\r\n \r\n
\r\n\r\nLogin URL
\r\ncontent_copy
https://oracle.com/cloud/sign-in.html\r\n
\r\n \r\n
\r\n\r\n\r\nScript to Create Student Account
\r\ncontent_copy
-- USER SQL\r\nCREATE USER STUDENT IDENTIFIED BY Temporary_Password_1234;\r\n\r\n-- ADD ROLES\r\nGRANT CONNECT TO STUDENT;\r\nGRANT RESOURCE TO STUDENT;\r\nALTER USER STUDENT DEFAULT ROLE CONNECT,RESOURCE;\r\n\r\n-- ENABLE REST\r\nBEGIN\r\n ORDS.ENABLE_SCHEMA(\r\n p_enabled => TRUE,\r\n p_schema => 'STUDENT',\r\n p_url_mapping_type => 'BASE_PATH',\r\n p_url_mapping_pattern => 'student',\r\n p_auto_rest_auth=> TRUE\r\n );\r\n commit;\r\nEND;\r\n/\r\n
\r\n \r\n
\r\n \r\nScript to Create Professor Account
\r\ncontent_copy
CREATE USER professor IDENTIFIED BY Temporary_Password_1234;\r\n\r\n-- ADD ROLES\r\nGRANT ACCHK_READ TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ADB_MONITOR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ADM_PARALLEL_EXECUTE_TASK TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ADPADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT APEX_ADMINISTRATOR_READ_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT APEX_ADMINISTRATOR_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AQ_ADMINISTRATOR_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AQ_USER_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AUDIT_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT AUDIT_VIEWER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CAPTURE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONNECT TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_DEVELOPER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_MONITOR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CONSOLE_OPERATOR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT CTXAPP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DATAPUMP_CLOUD_EXP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DATAPUMP_CLOUD_IMP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DCAT_SYNC TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DV_ACCTMGR TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DV_OWNER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT DWROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT GATHER_SYSTEM_STATISTICS TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT GRAPH_DEVELOPER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT HS_ADMIN_SELECT_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT LBAC_DBA TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ODIADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT OML_DEVELOPER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT OML_SYS_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT OPTIMIZER_PROCESSING_RATE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT ORDS_ADMINISTRATOR_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT PDB_DBA TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT PROVISIONER TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT RESOURCE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT SELECT_CATALOG_ROLE TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT SODA_APP TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_CACHE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_CONNECT TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_NAMESPACE_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\nGRANT XS_SESSION_ADMIN TO PROFESSOR WITH ADMIN OPTION;\r\n\r\nALTER USER PROFESSOR DEFAULT ROLE ACCHK_READ,ADB_MONITOR,ADM_PARALLEL_EXECUTE_TASK,\r\nADPADMIN,APEX_ADMINISTRATOR_READ_ROLE,APEX_ADMINISTRATOR_ROLE,AQ_ADMINISTRATOR_ROLE,\r\nAQ_USER_ROLE,AUDIT_ADMIN,AUDIT_VIEWER,CAPTURE_ADMIN,CONNECT,CONSOLE_ADMIN,\r\nCONSOLE_DEVELOPER,CONSOLE_MONITOR,CONSOLE_OPERATOR,CTXAPP,DATAPUMP_CLOUD_EXP,\r\nDATAPUMP_CLOUD_IMP,DCAT_SYNC,DV_ACCTMGR,DV_OWNER,DWROLE,GATHER_SYSTEM_STATISTICS,\r\nGRAPH_DEVELOPER,HS_ADMIN_SELECT_ROLE,LBAC_DBA,ODIADMIN,OML_DEVELOPER,OML_SYS_ADMIN,\r\nOPTIMIZER_PROCESSING_RATE,ORDS_ADMINISTRATOR_ROLE,PDB_DBA,PROVISIONER,RESOURCE,\r\nSELECT_CATALOG_ROLE,SODA_APP,XS_CACHE_ADMIN,XS_CONNECT,XS_NAMESPACE_ADMIN,\r\nXS_SESSION_ADMIN;\r\n\r\n-- ENABLE REST\r\nBEGIN\r\n ORDS.ENABLE_SCHEMA(\r\n p_enabled => TRUE,\r\n p_schema => 'PROFESSOR',\r\n p_url_mapping_type => 'BASE_PATH',\r\n p_url_mapping_pattern => 'professor',\r\n p_auto_rest_auth=> FALSE\r\n );\r\n commit;\r\nEND;\r\n/\r\n
"scripts":[]
}
]
}