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

Thread: Access to tables

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    India
    Posts
    10

    Exclamation

    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?

    Thanks

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