Main Page | Report this Page
Computers Forum Index  »  Computer - Databases - IBM DB2  »  DB2 9.7 Row level security...
Page 1 of 1    

DB2 9.7 Row level security...

Author Message
dunleav1...
Posted: Tue Oct 27, 2009 5:13 pm
Guest
Is there a redbook on implementing row level security in DB2 9.7 LUW ?
Can someone list the link, I can't find anything on IBM's site
regarding the topic.
Thanks,
JD
 
The Boss...
Posted: Wed Oct 28, 2009 1:38 am
Guest
dunleav1 wrote:
Quote:
Is there a redbook on implementing row level security in DB2 9.7 LUW ?
Can someone list the link, I can't find anything on IBM's site
regarding the topic.
Thanks,
JD

It's called "LBAC" (Label Based Access Control) and is delivered as an
optional feature called "Advanced Access Control Feature".

There is a Redbook "DB2 Security and Compliance Solutions for Linux, UNIX
and Windows" that also covers LBAC, but it is for 9.5:
http://www.redbooks.ibm.com/abstracts/sg247555.html

DeveloperWorks has a 2-part tutorial on LBAC (also 9.5 based) here:
http://www.ibm.com/developerworks/views/data/libraryview.jsp?search_by=LBAC+series
(registration needed for full access)

The Infocenter for DB2 9.7 contains a chapter on DB2's security model,
including LBAC:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.sec.doc/doc/c0021804.html

HTH.

--
Jeroen
 
dunleav1...
Posted: Mon Nov 02, 2009 4:09 pm
Guest
On Oct 27, 4:38 pm, "The Boss" <use... at (no spam) No.Spam.Please.invalid> wrote:
Quote:
dunleav1 wrote:
Is there a redbook on implementing row level security in DB2 9.7 LUW ?
Can someone list the link, I can't find anything on IBM's site
regarding the topic.
Thanks,
JD

It's called "LBAC" (Label Based Access Control) and is delivered as an
optional feature called "Advanced Access Control Feature".

There is a Redbook "DB2 Security and Compliance Solutions for Linux, UNIX
and Windows" that also covers LBAC, but it is for 9.5:http://www.redbooks..ibm.com/abstracts/sg247555.html

DeveloperWorks has a 2-part tutorial on LBAC (also 9.5 based) here:http://www.ibm.com/developerworks/views/data/libraryview.jsp?search_b...
(registration needed for full access)

The Infocenter for DB2 9.7 contains a chapter on DB2's security model,
including LBAC:http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index..jsp?topic=...

HTH.

--
Jeroen



Thanks.
Do you know if there is an additional license fee for this feature?
 
Ian...
Posted: Tue Nov 03, 2009 11:24 am
Guest
dunleav1 wrote:
Quote:
On Oct 27, 4:38 pm, "The Boss" <use... at (no spam) No.Spam.Please.invalid> wrote:
dunleav1 wrote:
Is there a redbook on implementing row level security in DB2 9.7 LUW ?
Can someone list the link, I can't find anything on IBM's site
regarding the topic.
Thanks,
JD
It's called "LBAC" (Label Based Access Control) and is delivered as an
optional feature called "Advanced Access Control Feature".

There is a Redbook "DB2 Security and Compliance Solutions for Linux, UNIX
and Windows" that also covers LBAC, but it is for 9.5:http://www.redbooks.ibm.com/abstracts/sg247555.html

DeveloperWorks has a 2-part tutorial on LBAC (also 9.5 based) here:http://www.ibm.com/developerworks/views/data/libraryview.jsp?search_b...
(registration needed for full access)

The Infocenter for DB2 9.7 contains a chapter on DB2's security model,
including LBAC:http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=...

HTH.

--
Jeroen



Thanks.
Do you know if there is an additional license fee for this feature?

Yes, the advanced access control feature is an extra-cost feature - and
it is only available if you have ESE.

http://www-01.ibm.com/software/data/db2/9/editions_features_advaccess.html
 
 
Page 1 of 1    
All times are GMT
The time now is Mon Nov 30, 2009 10:31 pm