SQL - simultaneous GC access ?

[David T.]

Sorry, no. Your assumption is incorrect*.

http://wiki.gnucash.org/wiki/FAQ#Q:_Can_I_use_GnuCash_with_multiple_users.3F_Maybe_via_the_SQL_backend.3F <http://wiki.gnucash.org/wiki/FAQ#Q:_Can_I_use_GnuCash_with_multiple_users.3F_Maybe_via_the_SQL_backend.3F>

David

* Technically, the answer would be “Yes, multiple users can acces a GnuCash SQL file at one time, as long as you don’t care about the accuracy or integrity of your financial data."
 
> On Feb 25, 2016, at 8:58 PM, __ <tereque at gmail.com> wrote:
> 
> thanks for the feedback. There is a discrepancy regarding on point though
> 
> 2.) Will using SQL also change the character of GC from being a single-user
> system to a multi-user system?
> 
> I'd assume any database allowed simultaneous access, so I tend to believe
> 'yes' would be correct?
> 
> 
> 
> On Sun, Jan 3, 2016 at 12:09 PM, Plutocrat <plutocrat at gmail.com> wrote:
> 
>> __ wrote on Sunday, 03 January, 2016 11:06 AM:
>>> I stumbled over comments in various threads that seem to refer to a
>> future
>>> implementation of SQL. Without all too much knowledge of the matter I
>>> assume that means that GC is going to store it's data in an SQL (assuming
>>> MySQL) database in the near future.
>> 
>> You already have the choice of storing in XML, sqlite and MySQL format.
>> Just use Save As to select a different data format. If you don't currently
>> see any choices, then you need to install the appropriate extensions. See
>> the documentation/wiki for details.
>> 
>>> 2.) Will that also change the character of GC from being a single-user
>>> system to a multi-user system?
>> 
>> No.
>> 
>>> 3.) if 2.) is right, will there be a authorization routine for user's to
>>> login?
>>> 4.) is there any plan to regulate access to certain parts of the
>> accounting
>>> to certain users? (for example a merchandiser being able to make
>> supplier's
>>> bills but not being able to access/see salaries)
>> 
>> Authorisation is currently by database name / user / password. You may be
>> able to do something clever with MySQL's internal per-table permissions to
>> control who sees what, but its not supported by Gnucash. In the future ...
>> who knows?
>> 
>> P.
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.