multiple server multiple users - HOWTO?
we have multiple server
e.g.: server01, server02, ...
multiple users:
user01, user02, ...
each user has a admin-user:
adminUser01, adminUser02, ...
we set them up as a connection without credential
we would like to have the credentials for the admin-user to be stored somewhere so that we would only have to edit/enter them once in the application
and could then select the connection for e.g. server01 and use the saved credentials "adminUser01" for windows user "user01" ...
hope i'm clear ...
thanks in advance for any comment ...
KR
guenther
All Comments (3)
Hi,
We will release a new video this week to explain it in more details. If you use a SQL Server data source, you can use the user specific settings by right clicking on the session and choosing the menu Edit Session (User Specific Settings).
This is available if you have created a user in the database from the menu File->Administration->Users
David Hervieux
hi!
i'm aware of this function .. but this way we would have to enter the user specific credentials for each server .. or am i wrong here?
when password changes every X days we would have to update all servers over and over again .. i know we have batch editing .. but it's still a bunch of work ...
i saw that you can define keywords .. if we would e.g. add the keyword "usercred" to all servers in question and would then be able to batch edit those would be a good workaround ...
please let me know what you think.
KR
guenther
Hi,
I think the the best solution is to allow you create a custom credential entry and use it. This entry could be saved in another database.
David Hervieux