Notes

SQL> CREATE USERTABLE SITA IDENTIFIED BY SITA01
USER CREATED.

SQL> GRANT CONNECT TO SITA;
GRANT SUCCEDED.

SQL> GRANT RESOURCES TO SITA;
GRANT SUCCEDED.

SQL> GRANT CONNECT TO SITA;
GRANT SUCCEDED;

SQL> CONN SITA/SITA01;
CONNECTED.

SQL> SELECT * FROM TAB; // to check the object in the schema.
SQL> CREATE TABLE EMP (EID NUMBER(5), ENAME CARCHAR2(40));
TABLE CREATED.

SQL> SHOW USERTABLE
USER IS "SITA"
SQL> INSERT INTO EMP VALUES(1, 'NAME');
1 ROW CREATED.

SQL> COMMIT;
COMMMIT COMPLETE.

SQL> SELECT * FROM EMP;

EID ENAME
----------- --------------
1 NAME

SQL> SELECT USERTABLE NAME FROM ALL USERS;

...
**********************************************************************
SQL> CREATE USER RITA IDENTIFIED BY RITA01;
USER CREATED.

SQL> GRANT CREATE SESSION, CONNECT, RESOURCE TO RITA;
GRANT SUCCEEDED.

SQL> CONN RITA/RITA01
CONNECTED.

SQL> SHOW USER
USER IS "RITA"

SQL> SELECT * FROM EMP;
SELECT * FROM EMP

ERROR AT LINE Q:
ORA-00942 TABLE OR VIEW DOES NOT EXIST

SQL> SHOW USER
USER IS "RITA"

SQL> CONN / AS SYSDBA
CONNECTED.

SQL> GRANT SELECT ON SITA.EMP TO RITA;
GRANT SUCCEEDED.

SQL> SELECT * FROM SITA.EMP;

EID ENAME
----------- --------------
1 NAME

SQL> INSERT INTO EMP VALUES(2, 'NAME2');
ERROR (INSERT PRILIVIGED NOT GRANTED)

SQL> GRANT INSERT ON SITA.EMP TO RITA;
GRANT SUCCEEDED.

SQL> CON RITA/RITA01;
CONNECTED.

SQL> INSERT INTO EMP VALUES(2, 'NAME2');
1 ROW CREATED.

SQL> COMMIT;
COMMIT COMPLETE.

**********************************************************************

SELECT OWNER, TABLE_NAME FROM ALL_USER; //SHOWS ALL USERS
SELECT OWNER, TABLE_NAME FROM ALL_USER WHERE TABLE_NAME = 'EMP';