Home » RDBMS Server » Networking and Gateways » OID Unique Users Not Guests (10.1.0.4)
OID Unique Users Not Guests [message #307179] Tue, 18 March 2008 01:44
aleks001
Messages: 1
Registered: March 2008
Junior Member
Hi Everyone,

Ok this is probably not gonna make sense cause my english sucks even though im in australia lol.

I have setup oid and the test database and when you connect you are connected as guest.

I.E:

select user from dual;

returns:

USER
------------------------------
GUEST

Is it possible and I hope to god it is that all the users that login are unique. Because I have a bunch of users and they all need to create tables and If they are all guest the tablenames will conflict sooner or later.

How do I go about making this happen so all the users from the OID have their own identitys. Because currently two different users can not both create a table called TABLE1.

How do I make it so two users can both create a table called TABLE1.

So it would be something like USER1.TABLE1 and USER2.TABLE1

All help is appreciated in advance.

Thanks Guys.

And for all the funny guys out there. I can't create indavidual schemas for all the users. If they can be automatically created thats fine but theirs way to many users.
Previous Topic: ERROR:ORA-12514
Next Topic: ODBC connection error with TNS-12154
Goto Forum:
  


Current Time: Thu Mar 28 20:23:00 CDT 2024