mirror of
https://github.com/BookStackApp/BookStack.git
synced 2026-02-13 11:19:37 +03:00
Minimum DB User Privileges to run app #383
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @slimninja on GitHub (Jul 25, 2017).
A question for you, potentially an update for your documentation as well. What are the minimum privileges granted to the main app DB user to use the application?
@Shackelford-Arden commented on GitHub (Jul 25, 2017):
@salimnanji Not sure if this is what you're looking for, but looking at the Ubuntu 16.04 script linked in the installation instructions, here is what I see for permissions granted to the user.
Hope that helps!
@slimninja commented on GitHub (Jul 25, 2017):
Ah I see, so it looks like it is granting all privileges, similar to how I have my user set up.
@ssddanbrown commented on GitHub (Jul 27, 2017):
Since database migrations are done as part of the app I'd advise the user should have pretty much all permissions. Some are likely not needed, Such as 'views' or 'routines' but I cannot guarantee that for the future.
If you really wanted to limit access you could do that by using a different .env options when migrating which would limit the required permissions for general daily use.
@slimninja commented on GitHub (Jul 28, 2017):
Thanks for the explanation! Good to know.