Re: Sharing objects between users in Oracle

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Wed, 19 Mar 2003 23:05:04 +0300
Message-ID: <b5aihh$evd$1@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@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 Wed Mar 19 2003 - 14:05:04 CST