DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001


    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?


  2. #2
    Join Date
    Apr 2001
    West Sussex, England
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.