Re: Grant all Object Privilege from User to User

For example, I want to create USER1 which has the same roles and privileges with USER2. However, the USER2 has the privilege to access OBJECT3 which create by USER3. So, when I create USER1 like USER2, the system shows that I don't have sufficient privilege. Does that because I don't have grant privilege for OBJECT3 from USER3?

If I want to grant all object privilege from USER3, how to do so? Or has any way to do?

Thanks in advance,

regards,
JK

"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:<9jgfiq$e4n$1_at_news247.cnt.ru>...
> 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 Tue Jul 24 2001 - 03:45:39 CDT