In DB2 10 new authorities have been introduced to separate data administration and data access:
- Security Administrator (SECADM)
- System DBA (SYSTEM DBADM)
- Data Administrator (DATAACCESS)
- Performance Specialist (SQLADM)
New row and column data access policy controls have been fully integrated into the database engine and apply to SELECT, INSERT, UPDATE and DELETE.