create user student1 identified by SQLClass2023;
grant create session to student1;
grant unlimited tablespace to student1;
grant select any table to student1;
grant all on world.city to student1;
grant all on world.continent to student1;
grant all on world.country to student1;
grant all on world.country_language to student1;
grant all on world.organization to student1;
grant all on world.country_organization to student1;
commit;
