Re: Grant all Object Privilege from User to User

Hello!

JK Yao <jkyf0131_at_hotmail.com> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:93f65984.0107221814.36ef2978_at_posting.google.com...
> 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?

If you whant logon as sysdba, you must create password file using orapwd (on Unix) utility.
After that you must add to init<SID>.ora -> "remote_login_passwordfile=exclusive" and restart Oracle. After that you may using password, created by orapwd.

>
> 2. Then I loggin as SYS in normal mode. When I "create user like", I
> cannot create that user with all same privilege.
Which privilege?

Best regards!
Yaroslav.
>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 Mon Jul 23 2001 - 01:23:55 CDT