Direct modification of grant tables using statements such as INSERT, UPDATE, or DELETE is discouraged and done at your own risk.
不鼓励使用诸如INSERT,UPDATE或DELETE之类的语句直接修改授权表及风险自己承担。
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them.
mysql系统数据库包括几个授权表,其中包含有关用户帐户及其拥有的权限的信息。
The discussion here describes the underlying structure of the grant tables and how the server USES their contents when interacting with clients.
这里的讨论描述了权限表的底层结构以及服务器在与客户端交互时如何使用它们的内容。
Therefore, GRANT commands are often included in the DDL after objects, such as tables, are created.
因此,GRANT命令通常会出现在 DDL中的对象创建语句之后,如数据表。
Figure 7 illustrates how you can edit and grant permissions to your users based on what tables, procedures, and views they are going to use.
图7显示如何基于用户要使用的表、过程和视图来编辑和授予用户权限。
The WITH GRANT OPTION is only available for the GRANT statements of packages, routines, schemas, tables, views, and table spaces.
WITHGRANTOPTION只能用于包、例程、模式、表、视图和表空间的 GRANT语句。
For example, if you choose not to access the repository using static SQL, you need to grant privileges to the repository tables themselves.
例如,如果您选择不使用静态SQL访问存储库,就需要将权限授予存储库表格本身。
You can grant EXECUTE permissions on stored procedures, revoking or denying permissions on the base tables.
您可以授予针对存储过程的EXECUTE权限,撤消或拒绝针对基表的权限。
You revoke or deny all permissions to underlying objects, such as tables, and grant EXECUTE permissions on stored procedures.
您可以撤销或拒绝基础物件 (例如资料表) 的所有权限,然后在预存程序上授与EXECUTE 权限。
You revoke or deny all permissions to underlying objects, such as tables, and grant EXECUTE permissions on stored procedures.
您可以撤销或拒绝基础物件 (例如资料表) 的所有权限,然后在预存程序上授与EXECUTE 权限。
应用推荐