db2权限管理

已经存在一个用户（在系统中创建用户），用户名是ccp


实例名db2fenc1,下边有个数据库test,有张表是test


grant select on table db2fenc1.test to user ccp

//授予所有的权限
grant all privileges on table db2fenc1.test to user ccp


-------------------------schema--------------------------------------

>>-GRANT----+-ALTERIN--+-+--ON SCHEMA--schema-name-------------->
+-CREATEIN-+
'-DROPIN---'

.-,---------------------------------.
V |
>--TO----+-+-------+--authorization-name-+-+-------------------->
| +-USER--+ |
| '-GROUP-' |
'-PUBLIC------------------------'

>--+-------------------+---------------------------------------><
'-WITH GRANT OPTION-'


-----------------------database--------------------------------------

>>-GRANT----+-BINDADD-------------------+-+--ON DATABASE-------->
+-CONNECT-------------------+
+-CREATETAB-----------------+
+-CREATE_EXTERNAL_ROUTINE---+
+-CREATE_NOT_FENCED_ROUTINE-+
+-IMPLICIT_SCHEMA-----------+
+-DBADM---------------------+
+-LOAD----------------------+
+-QUIESCE_CONNECT-----------+
'-SECADM--------------------'

.-,---------------------------------.
V |
>--TO----+-+-------+--authorization-name-+-+-------------------><
| +-USER--+ |
| '-GROUP-' |
'-PUBLIC------------------------'