It is currently Thu Apr 24, 2014 5:35 am




Post new topic Reply to topic  [ 6 posts ] 
 Authentication Profiles and database 
Author Message
Cadet
Cadet

Joined: Mon Jun 11, 2012 6:15 am
Posts: 5
Post Authentication Profiles and database
Hello,

In postgresql SGBDR, you can create roles to connect to a database.
I would like to create all of my roles with postgrelsql in order that ignition connect with these roles.
Ignition can authentificate with external database but it uses tables inside the database and not the roles already created for postgresql database connection.

What do you think ?

PS : I'm french.


Fri Jun 29, 2012 2:11 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 2:46 pm
Posts: 1982
Location: Sacramento, CA
Post Re: Authentication Profiles and database
Can you query the database for the roles? If so, you can use the expert mode of the database authentication where you specify three queries:

1) Authentication query
2) Role List Query
3) User's Roles Query

Rather than using the table structure Ignition expects.

_________________
Travis Cox
Inductive Automation
Technical Support Rep.


Fri Jun 29, 2012 5:01 am
Profile WWW
Cadet
Cadet

Joined: Mon Jun 11, 2012 6:15 am
Posts: 5
Post Re: Authentication Profiles and database
I forgot to say that i would like Ignition connects to my database with the username/password that was entered at the start of a client.
This a great interest in my opinion (I will explain it if necessary).


Fri Jun 29, 2012 5:34 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2417
Post Re: Authentication Profiles and database
Hi,

That has been requested before, but currently isn't possible. The database connections are currently pooled centrally, so the clients have no affect on them. However, it would be a good security addition, and plays in to a number of improvements that we would like to make, so hopefully we'll add it someday.

For now, the best you can do would be to create a user specifically for Ignition. If you want to go even further, you could create multiple users, and multiple connections to the same database, and then perhaps different projects which used them as the default. For example, you could have a full control project that used a connection with full read/write privileges. Then you could have a separate "guest" project, whose default connection only allowed reading.

Quote:
PS : I'm french.

Ça ne fait rien, nous aidons tout le monde également. :lol: (I'm joking, I know why you said that)

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Fri Jun 29, 2012 7:15 am
Profile
General
General

Joined: Wed Jun 16, 2010 11:28 am
Posts: 257
Post Re: Authentication Profiles and database
For this scenario, we can imagine to have a common windows (or project) with a custom login form and then log with db authentication with some scripting to open further windows or project with retargeting...


Fri Jun 29, 2012 7:25 am
Profile
Cadet
Cadet

Joined: Mon Jun 11, 2012 6:15 am
Posts: 5
Post Re: Authentication Profiles and database
Thanks for your reply. I'll wait for the feature :)


Sun Jul 01, 2012 11:02 pm
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: