Read only, or less privileged sql user.

[willcipriano]

Tell me if this belongs in a feature request, Is it possible to use a less privileged user with opendental for situations such as a remote working laptop? I remember attempting to create a read only user some time ago and open dental demanding grant rights.

[jsalmon]

It is not possible to use a less privileged user. They wouldn't be able to do anything once logged in because we require the user be able to run insert statements too much. E.g. our security log has inserts sprinkled all over the program and it would be a nightmare to try and surround those with a way to get into all the windows in a read only fashion.

What you really want to do is create a new 'less privileged' Open Dental user that can't edit anything within Open Dental.
http://www.opendental.com/manual/security.html

[willcipriano]

Won't work for what I'm trying to do, but thanks.

[cyberk]

Guys, let's not forget that creating a user, with full read/write access to the database, is indeed a less privileged user than root. You can create another mysql user, as long as it has the minimum privileges necessary for the application to function. Can you do ReadOnly? probably not...can logging in open dental be done through delegated stored procedures to a read-only user?, sure why not, will they ever improve the security in their software? who knows?

http://opendental.com/manual/securitymysql.html