Re: Is there any way to organize or group schemas inside an instance?
Date: Fri, 8 Jul 2011 15:22:41 +0000 (UTC)
Message-ID: <pan.2011.07.08.15.22.39_at_email.here.invalid>
On Fri, 08 Jul 2011 07:31:44 -0700, Big George wrote:
> Hello,
>
> I'm using TOad and Oracle 11g.
>
> I have a lot of shemas inside an instance... How to organize them? What
> I see is a long list of schemas which could be difficult to manage if
> number of schemas grows up... For example, I'd like to group Schema_1,
> Schema_2 and Schema_3 in something like Group_1, so it could be seen
> more organized.
>
> Group_1
> Schema_1
> Schema_2
> Schema_3
>
> Sometimes a java or .net application uses 3 or 4 schemas... these
> schemas are in the same instance which has other schemas for other
> applications.
>
> Of course, I can use an Excel file to organize schemas, but my question
> is if Oracle offer some functionality to do it.
Schemas can belong to various roles. There are pre-defined roles, like DBA, but you can also create your own like "INTERNAL_USER", "APP_USER", "DEVELOPER" or alike. You can then group schemas by the used roles.
-- http://mgogala.byethost5.comReceived on Fri Jul 08 2011 - 10:22:41 CDT