Oracle Tutorial#1: How to Create a new User & Table using Command Prompt & Grant Privileges

Oracle Tutorial#1: How to Create a new User & Table using Command Prompt & Grant Privileges to user in Oracle In Todays video I am going to perform certain functions with oracle database like creating new user, grant system/object privileges, create a table. To connect to our system database administrator account using this command: conn / as sysdba Set Alter Session true by running this command: Alter session set "_ORACLE_SCRIPT"=TRUE; To create a new user Named as Ibtisam. Create user Ibtisam identified by 1234567; To grant some privileges to our newly created user Ibtisam. grant create session, alter session,create table, create view to Ibtisam ; To create a table: create table example(id number(20), name varchar(100)); To show you the table description using: descr example; To grant object privilege to our new user Ibtisam, ----------grant select on Ibtisam.example to Ibtisam;