| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: adding new schemas without new user accounts ?
I don't think that is what he is asking Jack. (Though you are correct)
Andreas, I don't know if this is possible but I would look at creating a group and having that group be the owner of the schema. Otherwise just create a dummy account and give out the appropriate rights to the users to use that schema.
At 05:17 2000-05-26 -0800, you wrote:
>Hi
>
>No
>
>Not every user has to have a schema (if he/she doesn't own anything)
>
>
>Jack
>
>
>
>
>Andreas Jung <ajung_at_sz-sb.de>@fatcity.com on 05/26/2000 01:15:10 PM
>
>Please respond to ORACLE-L_at_fatcity.com
>
>Sent by: root_at_fatcity.com
>
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc:
>
>
>Dear all,
>
>I would like to seperate my tables by splitting them into logical schemas like
>DATA and MAIN with different permission for several users. Is it true that the
>name of schema is bound to an existing user account. I know that every
>user has
>its own schema. But can I add schema without adding a new (dummy) user ?
>
>Cheers,
>Andreas
>--
>Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>
>===================================================================
>De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
>de geadresseerde. Gebruik van deze informatie door anderen dan de
>geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
>en/of verstrekking van deze informatie aan derden is niet toegestaan.
>Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
>inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
>===================================================================
>The information contained in this communication is confidential and may be
>legally privileged. It is intended solely for the use of the individual or
>entity to whom it is addressed and others authorised to receive it. If you
>are not the intended recipient you are hereby notified that any disclosure,
>copying, distribution or taking any action in reliance on the contents of
>this information is strictly prohibited and may be unlawful. Ernst &
>Young is neither liable for the proper and complete transmission of the
>information contained in this communication nor for any delay in its
>receipt.
>===================================================================
>
>
>
>--
>Author: Jack van Zanen
> INET: nlzanen1_at_ey.nl
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
____EFGH_JKLM___QRSTUVWXYZ Received on Fri May 26 2000 - 09:21:07 CDT
 |
 |