Emerson Exchange 365

• Not Answered

DeltaV Live SQL Connection with dynamic user name

Hello Techies,

We need to connect to a custom SQL database from DeltaV Live.

DeltaV Live Administration allows to configure the SQL Connection object with below attributes:
1. ServerName
2. DatabaseName
3. ConnectionType (Trusted/Non-Trusted)
4. UserName
5. Password

We have been working great with the above attributes where UserName configured as DeltaVAdmin & Connection Type as Trusted.
The DeltaV user having assigned with the ADMIN role at DeltaV and Windows can connect with the SQL database.

With the DeltaV station on thin client, the Windows user is different than DeltaV User.
How can we connect to the SQL Server using current DeltaV user?
Need to do the code using TypeScript for a contextual display in DeltaV Live.

Let me know in case need further details.

Thanks in advance!

MPhatale

• 20 Mar 2021 11:25 PM
• Cancel

2 Replies

• Youssef.El-Bahtimy

  

  • 21 Mar 2021 4:36 PM

  First, I am not (yet) a Deltav live expert. Getting past that, I do have some critiques about the connection methodology. First, you should not, nor need to, have the SQL connection executing under the privileges of an OS and in this case critical control application administrator (Deltavadmin). In your target database, you should create a connect/read only account to access the database. If the user needs to write, make sure their scope is narrowed to only the tables they need access to. On the deltav side, the account should similarly be of the least privileges required to do their work, i.e. read a value from a database and present it in the live interface. If the mandate from the DV live software is for the user to be an administrator (unfortunately not an uncommon , though an artificial mandate) then create a new purpose built account to do this connection separate from Deltavadmin. As far as who is logged in interactively to the operating system, it should not matter provided the software runs these functions as a service or with the privileges of the designated user. The SQL connection should after all not be OS profile driven for an hmi whose function is to provide shared OS level access .

  • Cancel
• ALEXANDRE WASSERMAN

  

  • 21 Mar 2021 8:11 PM

  .j

  
  

  
  

  
  

  Enviado do meu Galaxy

  
  

  
  

  K..

  • Cancel