Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sharing same tablespace , can't see table of other user?

Re: sharing same tablespace , can't see table of other user?

From: Guido Konsolke <gk61_at_gmx.net>
Date: Fri, 6 Sep 2002 08:53:01 +0200
Message-ID: <1031294671.999417@news.thyssen.com>

"eugene kim" <eugene1977_at_hotmail.com> wrote...
> can't i set up a tablespace where user1, user2 can
> create,insert,delete,select tables?
> without worrying about granting priviledge?
>
> thank you

No, not to my knowledge.
If you really want different users to see each others objects than let them connect as the same user.

Please think about it: a user is the OWNER of everything that he creates in his schema. HE has to decide whether someone else should be able to read / modify his data or not.

hth,
Guido Received on Fri Sep 06 2002 - 01:53:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US