Hi Friends


You can follow this one for granting all permission of one user to another.

GRANT ALL ON <TABLE-NAME> TO <USER-NAME> [WITH GRANT OPTION]


ALL used to specify all of the object privilegs such as
ALTER DELETE INDEX UPDATE INSERT and SELECT

ON <TABLE-NAME> Specifies the table view or synonyms

TO <USER-NAME> Specifies to whom the privileges are granted

WITH GRANT OPTION Specifies that the grantee may pass on the privileges

that has been granted to another user.

I think that this is helpful