I'm creating a database with oracle and php for an assignment and i have to show the use of roles. i created a new role called employee and assigned it to a new user called employee1
CREATE ROLE read_only;
GRANT create session TO read_only;
GRANT select ON workson TO read_only;
GRANT select ON employee TO read_only;
GRANT select ON project TO read_only;
GRANT select ON department TO read_only;
CREATE ROLE employee;
GRANT read_only TO employee;
GRANT update ON employee TO employee;
GRANT insert ON workson TO employee;
Create user employee1 identified by qwerty1;
GRANT employee TO employee1;
Why does using any selects when connected as employee1 say there is no such table. select * from employee says there is no table. Did i form my roles wrong or something?