Re: Grant all Object Privilege from User to User

If I login as sys, I cannot grant privilege of all userA's object to userB. If you know how to do so, please let me know. Thanks a lot.

regards,
JK

"Yaroslav Perventsev" <p_yaroslav_at_cnt.ru> wrote in message news:<9jje0c$k6v$1_at_news247.cnt.ru>...
> Hello!
>
> JK Yao <jkyf0131_at_hotmail.com> ñîîáùèë â íîâîñòÿõ
> ñëåäóþùåå:93f65984.0107240045.69176b9c_at_posting.google.com...
> > 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.
>
> What is it mean user1 like user2?
> Which system???
> May be you use bad tools?
>
> If you login as sys, you can create any user.
>
> May be I something don't understand?
>
> Yaroslav.
>
>
>
> > 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 Thu Jul 26 2001 - 00:31:13 CDT