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------------------------'
页:
[1]