Home » RDBMS Server » Server Administration » Is there any way to organize or group schemas inside an instance?(2 Merged) (Oracle 11gR2, Windows Server 2003)
Is there any way to organize or group schemas inside an instance?(2 Merged) [message #515196] Fri, 08 July 2011 09:29 Go to next message
jbetetayahoocom
Messages: 6
Registered: October 2010
Junior Member
Hello,

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.
  • Attachment: Schemas.JPG
    (Size: 50.19KB, Downloaded 702 times)

Report message to a moderator

Re: Is there any way to organize or group schemas inside an instance? [message #515197 is a reply to message #515196] Fri, 08 July 2011 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Petition the SQL Standard Committee to add this feature to the SQL language

Report message to a moderator

Re: Is there any way to organize or group schemas inside an instance?(2 Merged) [message #515209 is a reply to message #515196] Fri, 08 July 2011 10:01 Go to previous message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
Not from the view that you are using. You could assign different users to different ROLES and organize them in that manner. That change will not be visible the way you are viewing them in the GUI but if you select from the database I believe ti would be dba_role_privs you could.

Regards
Tim

Report message to a moderator

Previous Topic: How can I count the connections exist on DB?
Next Topic: ORA01403 bring a database down?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 06:14:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.