[Solved] Connect per user roled

[ENTERPRISE INTERNATIONAL SAS]

Hi

I'm trying to use ORM with Oracle database but I have a specific connection scenerio for any user of our software. All software users must exist as user roled (created and granted into database), so for example, there is an ADMIN user that login to our software to access to all options and modules. this user is created into Users table into System schema into our Database, but also must be create by CREATE USER ... as object into database for connection autentication purposes. Is it possible this?

<add name="BDConexionPrincipal" connectionString="Data Source=SOLAR;User Id={UID};Password={PID};" providerName="System.Data.OracleClient"/>

I replace {UID} and {PID} with the user and password login respectively.

My second question related with this is, it is possible via ORM to create users or execute DDL sql instructions?

thanks

[Damyan Bogoev]

Hi Ramiro,

1.    You could instantiate an OpenAccessContext instance providing a custom connection string:

…
YourContextName context = new YourContextName(connectionString);
…

2.    I am afraid that you are unable to create new users using Telerik OpenAccess ORM. In fact you could execute a custom sql script using the InitSql setting. With the InitSql backend configuration element you can specify a SQL fragment that is executed when a new connection is opened.
Hope that helps.

Regards,
Damyan Bogoev
the Telerik team

[Damyan Bogoev]

Hi Ramiro,

Firstly I want to apologize for the inconsistent information in my last answer.
Actually you could prepare and execute custom sql statements. I prepared a sample application which demonstrates how to achieve that goal.
Additional information can be found here, here and here.
Hope you will find the provided information useful.

All the best,
Damyan Bogoev
the Telerik team