Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sharing objects between users in Oracle
Thank you all very much for helping out.
Yes, of course that's what "grant" is there for. I guess I've used Oracle graphic tools for too long.
Regards,
Roman Zhovtulya
"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message
news:b5aihh$evd$1_at_babylon.agtel.net...
> That's where
>
> GRANT <permission> ON mytable TO otheruser
>
> comes into play. SYNONYMs can also help, but keep in mind that
> synonyms for ADTs (user types) are only available since 9.2, with
> previous versions you have to reference them with owner. prefix.
> And don't forget to grant EXECUTE on object types themselves.
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
>
> "Roman Zhovtulya" <roman_at_fh-offenburg.de> wrote in message
news:b5abcp$8o8$1_at_news.BelWue.DE...
> > Hello,
> > Thanks for all the answers to my previous post.
> > I've found DBOne to be pretty nice and it can actually do what freeware
Toad
> > doesn't (manipulating Object-Relational stuff).
> >
> > But one more question, please.
> > How would I get several normal Oracle users to share the same objects
(like
> > tables, etc)?
> >
> > The idea is to create a database model once that several users can use
> > simultaneously. Now I need to create all the tables every time I add a
new
> > user, since one user is not able to see the tables of the other one.
> >
> > Thanks a lot,
> > Roman Zhovtulya
> >
> >
> >
> >
Received on Thu Mar 20 2003 - 14:01:45 CST