I'm running into a problem here when I'm trying to deploy RDM to our userbase: When they try to connect to the data source for the first time, they get an error that they do not have permission to INSERT into 'UserInfo'. This is by design, and not something I can get our DBAs to change
Ideally users would be created like this:
The workaround is to manually create every user (or just script it) prior to them logging in for the first time. Is this something that's possible in RDM or only in RDM Server?
Create new user in RDM, but not as SQL user