| 1. | Select on system catalog tables and views to public
将系统编目表和视图上的select授予public |
| 2. | All information catalog tables should be stored in a single - partition tablespace
所有信息编目表都应该存储在单一分区表空间中。 |
| 3. | The catalog partition is the database partition where the catalog tables for the database are stored
编目分区是存放数据库编目表的数据库分区。 |
| 4. | In order to find out what authorities you have , issue the command get authorizations , which queries system catalog table syscat . dbauth
命令需要什么权限，该命令用于查询系统编目表syscat . dbauth 。 |
| 5. | To ensure fast recovery of the partition containing system catalog tables , avoid placing user tables on the same database partition
为了确保包含系统编目表的分区能够快速恢复，应避免将用户表也放在那个数据库分区上。 |
| 6. | Create db2 cube views stored procedures and metadata catalog tables by running : db2 connect to edwdb db2 - tvf insthome sqllib misc db2mdapi . sql home db2mdapi . out
通过运行下列命令创建db2 cube views存储过程和元数据编目表： |
| 7. | You can determine this by executing runstats on the table space and then checking the nearindref and farindref columns of the db2 catalog table sysibm . systablepart
您可以通过对表空间执行runstats ，然后检查db2编目表sysibm . systablepart的nearindref和farindref这两列来判断上述情况。 |
| 8. | Instance level authority levels sysadm , sysctrl , sysmaint , and sysmon and group membership are defined outside of db2 udb , and are therefore not reflected in system catalog tables
实例级权限级别（ sysadm 、 sysctrl 、 sysmaint和sysmon ）和组成员关系是在db2 udb之外定义的，因此不会反映在系统编目表中。 |
| 9. | We also discussed some of the finer details of privileges , including implicit privileges , the differences in authorization between static and dynamic sql , and how privilege information is stored in the system catalog tables
还讨论了特权的某些细节，包括隐式特权、静态和动态sql之间授权方式的差异以及特权信息如何存储在系统编目表中。 |
