Grant all Object Privilege from User to User

dear all,

Anyone knows how to grant all object privilege to another user? 1. I loggin as SYS with sysdba, but got wrong username/password. How to solve it?

2. Then I loggin as SYS in normal mode. When I "create user like", I cannot create that user with all same privilege. I think the problems is that I don't have the grant privilege for those object with user schema. Can anyone help?

Thanks in advance,

regards,
JK Received on Sun Jul 22 2001 - 21:14:39 CDT