DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to grant using dblink?

  1. #1
    Join Date
    Sep 2001
    Location
    Jurong East/Singapore
    Posts
    70
    Hi
    I've two oracle databases with each one schema and user.

    I had created dblink between these databases.

    How do I give grant option to other database schema
    user from the previous one for some objects.

    regards,

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    When you create a db link, you always should use a user to connect to the remote database, if this user has the grant with grant option through the objects, then the use could give permissions on this objects to other users.

    Cheers

    Angel

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    Hi before creating a database link .

    grant permission has to be given to the dblink user and then create a database link

    grant select on table_neme to remote_link_user ;

    create database link link_name connect to remote_link_user using database_alias ;

    Hope it is clear .

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