grant access to remote user

[poojaDB]

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]

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

[docdiesel]

Hi,

I moved it to the correct forum.

Regards,

Bernd

[debasisdas]

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.

[amitpatel66]

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.