Row Level In DB2

vadivelanvaidyanathan · #1 (**permalink**) 08-08-2007, 12:45 AM

Is this possible to implement row level security in DB2? I am trying to find ways to restrict User access to table rows in other words if users query on table they can access certain rows but not all of them.

Murali · #2 (**permalink**) 08-09-2007, 06:55 AM

Hi vadivelanvaidyanathan,

Noway its possible, the privileges can be grant to the other users based on the objects and not on the certain values prsent in that.

But u can grant select privelege for selecting the object values alone.

But cannot able to give him privilege for selecting certain rows from that object.

katsnelson · #3 (**permalink**) 08-11-2007, 06:13 AM

The DB2 feature you are looking for is called Label Based Access Control or LBAC. Basic premise is that you can attach labels to database objects and database users and permit access to data when the labels match. Labels can be assigned to rows or columns giving you ability to implement row level security and ability to restrict access to specific columns. Take a look at this tutorial DB2 Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in DB2

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Roles & responsibilities of an SQA in a CMMI Level company?	vigneshgets	Software Testing	5	11-14-2008 05:17 AM
Why I am getting an error message which says " XML document must have a top level ele	itbarota	PHP Programming	1	07-26-2007 12:28 AM
Is there possible of getting battery level of mobile using j2me?	mobilegeek	J2ME	1	07-23-2007 12:14 AM
What are the Page level transaction and class level transaction?	H2o	Other Web Programming Languages	1	07-20-2007 02:48 AM
difference between cmm level and Six Sigma company?	vigneshgets	Software Testing	1	03-26-2007 11:04 PM