DB SEcurity:
1)Primary Authorization ID
2)Secondary Authorization ID
3)SQLID
These three security methods are eligible to secure data access.
Method 1:
You can secure data access by means of privilleges either specific functions. The privillege can be implicit or explicit.
Method 2:
You can secure your DB2 dataset access by means of implimenting RACF.
Method 3:
You can secure DB2 data access by means of encryption technique.
Implicit:
By Default or By Automatic. The user has certain level of privilleges by the means of implicit. If I am a owner or creater of an object by default i have read, delete, update, insert and create index. Suppose I'm a users of others object then permission to access a data done by means of explicit privileges.
(Grant All on table tablename to public;)
0 comments:
Post a Comment