Page 1 of 1
Read only, or less privileged sql user.
Posted: Sat Mar 28, 2015 10:11 am
by 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.
Re: Read only, or less privileged sql user.
Posted: Mon Mar 30, 2015 9:35 am
by 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
Re: Read only, or less privileged sql user.
Posted: Sat May 16, 2015 1:19 pm
by willcipriano
Won't work for what I'm trying to do, but thanks.
Re: Read only, or less privileged sql user.
Posted: Wed Aug 12, 2015 8:44 am
by 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