X Tutup
The Wayback Machine - https://web.archive.org/web/20201015014213/https://github.com/APIJSON/APIJSON/issues/130
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

请问如何配置用户访问表的权限 #130

Open
yoyogis opened this issue Apr 25, 2020 · 1 comment
Open

请问如何配置用户访问表的权限 #130

yoyogis opened this issue Apr 25, 2020 · 1 comment

Comments

@yoyogis
Copy link

@yoyogis yoyogis commented Apr 25, 2020

您好,请问apijson-java版能不能实现某个用户只允许访问某些表的权限控制。我看到 #12 中通过userId列设置用户对row的访问权限。这需要在业务表中加入userId列。这是row级的权限控制。
目前apijson能不能实现表级的权限配置,例如只允许用户A查询表mytable,而且不要求mytable中非要有userId列。
我能想到一个思路是在Access表中加一列owner。

ps1: 文档理解的还不是很全,如有说错,多包涵。
ps2:apijson设计和实现真的很赞!!!

@TommyLemon
Copy link
Member

@TommyLemon TommyLemon commented Apr 28, 2020

是这样,但对不同角色有不同的表访问控制的需求,基本只有 普通用户 和 系统管理员 共用一个 schema 才会出现,可以通过 Access 表配置角色来实现,例如只允许 ADMIN 对部分表来 CRUD。
另外你的思路也是可行的。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants
You can’t perform that action at this time.
X Tutup