DB29 for Linux,UNIX,and WINDOWS - section 4(DB2 Security)

1. Authentication.

a.Server

b.Client

c.Kerberos

d.Data-encrypt

e.Gssplug-in

SQL.:

1)get database manager configuration

2)update DBM cfg using authentication server

 

 

2.Privilege

a.SYSADM

b.SYSCTRL

c.SYSMAINT

d.SECADM

e.DBADM

f. Load

SQL:

1)update DBM CFG using SYSADM_GROUP TOPADMINGROUP

 

 

3.Authority.

a.Control

b.Select,insert,update,delete.

SQL:
1)GRANT control on table tables to user user1

2)revoke all on table table1 from group group1

 

set session/transfer ownership

 

 

4.LBAC

restrict the access to row/column, not use view.

 

 

5.Audit for sysadm