I generally give ALL privileges. Xataface needs to be able to create a few tables for book keeping and for performance improvements.
If you really want to be stingy, you could set up the Xataface application on a separate database from your main one, and just create views for the tables that you need.
e.g.
If your main database is called "dba", and you just want to allow access to the "customers" table from dba, then you could create another database "dbb", and create a view on it:
- Code: Select all
use dbb;
create view customers as select * from dba.customers;
Give the XF app full permissions to dbb and no permissions to dba.
-Steve