DB29 for Linux,UNIX,and WINDOWS - section 4(DB2 Security)
来源:互联网 发布:易语言加载驱动源码 编辑:程序博客网 时间:2024/04/23 16:31
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
- DB29 for Linux,UNIX,and WINDOWS - section 4(DB2 Security)
- DB29 for Linux,UNIX,and WINDOWS - section 5(DB2 Object)
- DB29 for Linux,UNIX,and WINDOWS - section 6(DB2 SQL)
- DB29 for Linux,UNIX,and WINDOWS - section 9(DB2 Concurrent)
- DB29 for Linux,UNIX,and WINDOWS - section 11(DB2 storage)
- DB29 for Linux,UNIX,and WINDOWS - section 13(DB2 performance)
- DB29 for Linux,UNIX,and WINDOWS - section 1(DB2 product family)
- DB29 for Linux,UNIX,and WINDOWS - section 12(DB2 data maintenance)
- DB2 UDB v8 Handbook for Windows and UNIX/Linux
- DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep (6th Edition)
- 利用 Oracle 10g 技能学习 DB2 9.1 for Linux, UNIX and Windows
- 利用 Oracle 10g 技能学习 DB2 9.1 for Linux, UNIX and Windows
- 利用 Oracle 10g 技能学习 DB2 9.1 for Linux, UNIX and Windows
- Recommended reading list: DB2 for Linux, UNIX, and Windows database administration
- 一种经济有效的使用值压缩 DB2 for Linux,UNIX,and Windows 数据库
- 为 IBM DB2 for Linux、UNIX and Windows 以及 IBM Content Manager 编写自动安装脚本
- 利用 Oracle 10g 技能学习 DB2 9.1 for Linux, UNIX and Windows
- 利用 Oracle 11g 技能学习 DB2 9.7 for Linux, UNIX and Windows
- Java_对象克隆
- 汇编语言笔记(二)
- 不用USBASP芯片也可用USB,纯AVR实现USB通讯:AVRUSB
- gloox连接openfire失败的解决方法
- C# 编码规范和编程好习惯
- DB29 for Linux,UNIX,and WINDOWS - section 4(DB2 Security)
- SSL机制简介
- 毕业规划
- Linux 汇编语言开发指南
- 假期学习总结
- Qt编程技巧 Qt 国际化
- java随笔之类属性的初始化
- 从春晚“捐款”对“一句话的事”到“阿凡达”对“拆弹部队”
- MySQL 的触发器、存储过程、函数、视图实验