OraFAQ Forum: SQL & PL/SQL » SCHEMA RELATED HELP.. I want to create 2 schemas under 1 username..

Home » SQL & PL/SQL » SQL & PL/SQL » SCHEMA RELATED HELP.. I want to create 2 schemas under 1 username..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sat, 02 February 2002 07:48

CATHYBEE
Messages: 20
Registered: January 2002

Junior Member

What i am trying to do is have 2 schema's under one username..

EXAMPLE:

My username is 'BOB'.
I want to create 2 schema's under the username bob.

OWNER BOB:
SCHEMA D0 with
table1, table2, index1, view1 etc...

OWNER BOB:
SCHEMA D1 with
table3,table4,index2,view2 etc...

How do i do that?

I want my SCHEMA NAME to be different than the USERNAME..

Report message to a moderator

Sat, 02 February 2002 12:03

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

it is not possible. what you can do is create 2 users (schemas) and give access to one user on both schemas

1) create user bob

2) create user bob1

3) grant all on table3 to bob
...

Report message to a moderator

Thank You SURESH!! [message #18528 is a reply to message #18511]

Mon, 04 February 2002 09:06

CATHYBEE
Messages: 20
Registered: January 2002

Junior Member

Thank You SURESH!!

Report message to a moderator

Previous Topic:	Date Problem A Serious One
Next Topic:	I need help... could you help me?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 13:54:36 CDT 2024