Access to tables Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Access to tables

  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