In other words, if all access to a table is static, the DBA would not need to grant access to the entire table or view, just to the package.

换句话说，如果对某个表的所有访问都是静态的，则DBA将不需要授予对整个表或视图的访问权限，而是仅授予对包的访问权限。

youdao

Therefore, if all access to a table is static, you would only need to grant access to the package, not the entire table or view.

因此，如果对一个表的所有访问都是静态的，您仅需要授权给程序包，而非整个表和视图。

youdao

The WITH GRANT OPTION is only available for the GRANT statements of packages, routines, schemas, tables, views, and table spaces.

WITHGRANTOPTION只能用于包、例程、模式、表、视图和表空间的 GRANT语句。

youdao

In Listing 3, you see that the user EMMA has CONTROL privilege on the table TABLE1 as well as all the other available table privileges, including the ability to grant those privileges to other users.

在清单3中，可以看出用户EMMA具有表table1上的CONTROL特权，以及所有其他可用的表特权，包括将这些特权授予其他人的能力。

youdao

Listing 6 shows the permissions to grant to the WORK table in the example.

清单6显示了在这个例子中分配给work表的权限。

youdao

Use the following MySQL commands to create the database, grant permissions on it, and add a table to it.

使用下面的MySQL命令创建数据库，并对其授权，然后向这个数据库中添加一个表。

youdao

For example, consider the SQL statement grant select on table user1.t1 to FOO, where DB2 doesn't know whether FOO is a user or group.

例如，考虑sql语句grantselectontable user1 . t1toFOO,DB 2不知道foo是用户还是组。

youdao

SQL> grant create table to wanghao;

授予创建表的权限。

youdao

SQL> grant create table to wanghao;

授予创建表的权限。

youdao