Re: Grant all Object Privilege from User to User

Hello!

If you login as sys, you cat grant only system privilege. If you want grant object privelege, you must login as owner of objects or user with privilege on needed object "with grant option".

Yaroslav.

JK Yao <jkyf0131_at_hotmail.com> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:93f65984.0107252131.6a606aec_at_posting.google.com...
> 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 - 03:09:38 CDT