Read only, or less privileged sql user.
-
- Posts: 24
- Joined: Fri Aug 08, 2014 7:55 am
Read only, or less privileged sql user.
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.
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
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
The best thing about a boolean is even if you are wrong, you are only off by a bit.
Jason Salmon
Open Dental Software
http://www.opendental.com
Jason Salmon
Open Dental Software
http://www.opendental.com
-
- Posts: 24
- Joined: Fri Aug 08, 2014 7:55 am
Re: Read only, or less privileged sql user.
Won't work for what I'm trying to do, but thanks.
Re: Read only, or less privileged sql user.
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
http://opendental.com/manual/securitymysql.html