I have created a user Iyappan and granted Resource and Connect using the following,
SQL>Create user Iyappan
Identified by iyappan;
SQL>Grant Connect to Iyappan;
SQL>Grant Resource to Iyappan;
I cannnot able to access the objects owned by user scott.
I want access to the tables and objects owened by scott.
Can any one tell me a solution?
Login as SCOTT and you can grant access on the tables to IYAPPAN. To grant selects, updates, deletes and inserts, use :
grant select, update, delete, insert on EMP to IYAPPAN;
You will then be able to access EMP from IYAPPAN using SCOTT.EMP
You can also create a synonym on EMP for IYAPPAN to avoid having to include the schema name when accessing the table.