DB2 연결 계정 권한 부여

JTS/CCM/QM 데이터베이스를 작성한 후에,
아래 커맨드를 실행하여 db2admin에 dbadm 권한을 부여합니다.


dbadm 권한 부여
참조: http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0000958.htm

db2 connect to CCM
db2 grant dbadm on database to user db2admin
db2 disconnect CCM

>>-GRANT----+-BINDADD-------------------+-+--ON DATABASE-------->
            +-CONNECT-------------------+
            +-CREATETAB-----------------+
            +-CREATE_EXTERNAL_ROUTINE---+
            +-CREATE_NOT_FENCED_ROUTINE-+
            +-IMPLICIT_SCHEMA-----------+
            +-DBADM---------------------+
            +-LOAD----------------------+
            +-QUIESCE_CONNECT-----------+
            '-SECADM--------------------'
 
>--TO----+-+-------+--authorization-name-+-+-------------------><
         | +-USER--+                     |
         | '-GROUP-'                     |
         '-PUBLIC------------------------'
 

dbadm 권한 회수
참조: http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0000981.htm

db2 connect to CCM
db2 revoke dbadm on database from user db2admin
db2 disconnect CCM