Tag Archives: db2icrt

Manage DB2 Table Security and Accessing It Using PHP

Security always considered on many application especially when dealing with e-commerce. DB2 has an ability to set table security with only one line of codes.

Some tables might be accessed by public or anonymous users but others can only be accessed by private users. In order to set that we need to understand grant and revoke DB2 syntax.

Grant is giving user some permissions to a table whereas Revoke is taking user from some table permissions.

I will give example of DB2 syntaxes to set tables security start from creating DB2 instance, create a database, schema, table and grant tables. Also there is PHP web apps to ‘select’, ‘insert’ and ‘update’ to these tables. I’ve used Windows OS and DB2 (ver)..

I am using db2admin user to set initial configuration. db2admin is OS and DB2 user created when I installed DB2 software. db2admin acts as administrator in DB2. FYI DB2 user is also OS user.

Continue reading