Jul 14, 2010 11:08 AM
row security question
-
Like (0)
We've been looking into row-level security to see if it might be useful for us.
In a row-secure table, there is an automatically generated column called _sec_label, which has three attributes: security level, category, and cohort.
Users can be given these three attributes. When deciding whether a user can view a row, the user's attributes are matched against the _sec_label attributes.
My question is, how can I find out what attributes a user has? There doesn't seem to be anything about how to do this in the Security Admin manual -- but I don't understand how you could manage row-level security without being able to do this.
Best regards,
drosenthal
The _V_USER_SECURITY view can be used to see what security label is assigned to each user.
You may also find these views useful:
_V_SECURITY_CATEGORY
_V_SECURITY_COHORT
_V_SECURITY_LEVEL
_V_SECURITY_COHORT_HIERARCHY
_V_USER_SECURITY
I think this all are views ..
_V_SECURITY_CATEGORY
_V_SECURITY_COHORT
_V_SECURITY_LEVEL
_V_SECURITY_COHORT_HIERARCHY
_V_USER_SECURITY
can i get some information about data model and how TOE generated session security profile,its value and how it match with security discriptor (security labels) present in this tables ?

