column level authorization?
Up to DB2column level authorization?
Posted by Pawan at July 28. 2008Dear All,
I did table level but not getting how to give column level authorization?
Its not possible in db2 if yes then how?
I want to give access of perticular field of table not whole of table.
Thanks
Pawan
Re: column level authorization?
Posted by perallis at July 28. 2008Hello Pawan,
Yes, you can give access of perticular field, but it is just possible on DB2 Version 9.
For a successful import operation into a table with
protected rows, you must have LBAC (label-based access control) credentials.
You must also provide a valid security label, or a security label that can
be converted to a valid label, for the security policy currently associated
with the target table.
Click here for more details
Re: column level authorization?
Posted by Saurabh at August 21. 2008Check this out as well http://www.ibm.com/developerworks/exchange/dw_entryView.jspa?externalID=326&categoryID=977