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???