我有一个数据库,想要分配角色和特权。
我的目标是允许多个用户(都具有相同的特权)能够创建,编辑和查看表(仅此而已)。
I understand there are user table privileges that allow a user to Create, alter, drop and delete
items in tables. But I also understand that there is a
resource user
pre-defined role that allows a user to do the same thing.
我会同时担任这两个角色吗?表级特权和预定义角色?如果我同时提供两者,将会发生什么?我可以吗?