I need to test some databases as a User Role. I see this option under Preferences | Client, but nothing happens when checked, and the file remains with full access.
The security options have been set as User/Dev/Dev.
Am I missing something?
There is no way to simulate a User role – you simply have to log on with a User password. Then you have to switch back to a higher role to do development. You can do this without actually logging off.
The "Simulate Client Role* popup only applies to communications between the client and the server. This is something I used for debugging/testing of the server, I can’t offhand think of a scenario where it would make sense for anyone else to use this option.
Yes, this is how I have been doing it, when I saw the simulate option. Thanks for clarifying.