Re: Grant all Object Privilege from User to User

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 Tue Jul 24 2001 - 04:15:25 CDT