Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

Hi Folks. I want to remove a user account from my Fleet server. Can I just delete this user's row from the database?

It may cause errors if that user has created any queries/packs. I haven’t tested this myself

Also, you will no longer be able to associate the distributed query history with that user if they have run any

Would the only trace of that user be in the `users` table? It wouldn't conflict with anything else?

It seems like if I were to delete that row, it may cause some conflicts with other tables in the DB. I want to make sure it won't before I go and delete it

Off the top of my head, if they haven't even logged in, you should be good to go.  The best supported option is to disable the account. I intend to add supported deletion at some point.