Checking database access

[Antarctica]

I have implemented ODBC connection check, but I am unable to check that the user provided has in fact access to the database given (read, write and schema).

With a user that has no permissions on database "testdb", the connection check runs through okay, but when trying to connect for install, the installer then returns {SQL_STATE: 42000} Cannot open database "testdb" requested by the login. The login failed.

Is there a feature somewhere to get the user permissions after odbc connection check or would that be a custom action?

[Daniel]

Hello,

I'm afraid we don't have predefined support for this check. You can try to create and develop your own custom action for this indeed.

All the best,
Daniel