SQLite用户权限

I covered user permissions in MySQL and PostgreSQL.

我介绍了MySQL和PostgreSQL中的用户权限。

One thing to note about SQLite is that permissions management, using GRANT and REVOKE, is not available.

关于SQLite需要注意的一件事是使用GRANT和REVOKE权限管理不可用。

It’s not available because it’s not possible.

它不可用，因为它不可能 。

The reason is that an SQLite database is self-contained in a single file.

原因是SQLite数据库是独立包含在单个文件中的。

This is due to the SQLite architecture.

这是由于SQLite体系结构。

Anything with access to SQLite file can access anything inside the database.

有权访问SQLite文件的任何内容都可以访问数据库内部的任何内容。

There is no way to give permissions at the database level.

无法在数据库级别授予权限。

If your application needs to implement user permissions, you can do so at an application level, for example in your API server, but it’s up to you.

如果您的应用程序需要实现用户权限，则可以在应用程序级别(例如，在您的API服务器中)实现此权限，但这取决于您。

If your app must need user permissions, you could also reconsider your DBMS choice and prefer PostgreSQL of MySQL/MariaDB instead.

如果您的应用程序必须需要用户权限，则还可以重新考虑选择DBMS，而改用MySQL / MariaDB的PostgreSQL。

翻译自: https://flaviocopes.com/sqlite-user-permissions/