grant access to remote user

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • poojaDB
    New Member
    • Jun 2008
    • 1

    grant access to remote user

    i am trying to exceute this query inorder to give select permission on table to a user on remote server:

    GRANT select ON schema1.table_n ame TO 'user'@'domain' IDENTIFIED BY 'pwd';

    i am getting the error

    ORA-00987 :missing or invalid username(s)


    any solution???
  • niladri123
    New Member
    • Dec 2007
    • 8

    #2
    I think u can ask in oracle forum....
    By mistake u have putted in db2

    Comment

    • docdiesel
      Recognized Expert Contributor
      • Aug 2007
      • 297

      #3
      Hi,

      I moved it to the correct forum.

      Regards,

      Bernd

      Comment

      • debasisdas
        Recognized Expert Expert
        • Dec 2006
        • 8119

        #4
        you cant grant on another schema object unless you have logged in through sys /system account.

        You can't grant to another user in another domain. You need to use DB Link for that.

        Comment

        • amitpatel66
          Recognized Expert Top Contributor
          • Mar 2007
          • 2358

          #5
          Yes you will need a dblink to grant access on the table from another database.

          [code=oracle]

          GRANT select ON schema1.table_n ame TO 'user'@'domain' IDENTIFIED BY 'pwd';

          [/code]

          And also do not use the single quotes for the user name and password.

          Comment

          Working...