Re: Shared Schema

If you mean multiple users logging into the same account ... this "feature" has been present since at least 7.0 (I don't have any earlier docs). If you mean different Oracle accounts being able to access the same schema ... this too has been supported since at least 7.0 -- but only those users (including PUBLIC) that have been granted privileges by the owner of the schema will have access rights and unless the owner has created synonymns for the table names all references will have to be in the form <owner>.<table_name>

hth
jerry gitomer

Anurag Minocha wrote in message
<3837C96C.564B8E9E_at_synergy-infotech.com>...
|Hi,
|I read somewhere that we can have a shared schema in Oracle 8i
where
|multiple users can connect to the same schema .
|Was this feature introduced in 8i or it has been there in 8.0.5
also.
|
|
|Thanks
|Anurag
|
|also reply at
|anurag_at_synergy-infotech.com
|
Received on Tue Nov 23 1999 - 00:27:28 CST