在清单3中,可以看出用户EMMA具有表table1上的CONTROL特权,以及所有其他可用的表特权,包括将这些特权授予其他人的能力。
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.
用于访问外部表的权限由IDS通过外部表上的用户访问特权治理,还受到由操作系统管理的数据文件权限的治理。
The permissions used to access external tables is governed by the user access privileges on the external table by IDS as well as the data file permissions managed by the operating system.
只要没有其他更新wells_pts的方法(即,必须从所有其他用户那里撤消修改这个表的特权),那么引用完整性就是有保证的。
As long as there is no other way to update wells_pts (that is, you must revoke privileges from all other users), referential integrity is guaranteed.
应用推荐