Devart Forums

I created a user in oracle using the following.

create tablespace user3_ts
logging
datafile 'user3_ts'
size 32m
autoextend on
extent management local;

create user user3
identified by password3
default tablespace user3_ts
TEMPORARY TABLESPACE user3_ts

grant connect to user3

grant create session, create table, create view to user3

When I connect to oracle using corelab, it connects me to the system tablespace and not the user3_ts tablespace. How do I get corelab to see only the user3_ts tablespace and not the system tablespace when issuing queries or programmatically creating tables?

Thanks,
Irfan

Try to check this with SQL Plus. Oradirect .NET should connect to user3_ts
schema. This schema will become current (if ConnectMode=OracleConnectMode.Default).

Thank you. It worked.

I have another question. Is it possible to tell the Oradirect .NET to connect to a particular tablespace or schema assuming the user has access instead of the default one?

Thanks,
Irfan

OraDirect .NET operates same way as other providers.
You can connect to any schema very simple. Just connect to appropriate user, and this will be connection to his schema. Then you can execute and switch to another schema. A tablespace will be that, in which current schema resides.
For more information please see Oracle documentation.

Thank you. I was hoping for something more automatic when creating the connection. For now I will just change the database connection creation code to always issue this command before returning the connection to the calling code.

Thanks,
Irfan

You are welcome.