Wednesday 13 February 2013

DB2 Security in Mainframe Computer Systems



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

Powered by Blogger.