PermissionCondition in PhysicalTable

[DanielC]

Hi, I want to conditional access security to the rows of a table. For this I wrote the following commands:

METADATA_GETNOBJ numObj = ("omsobj: DataTable? @ Name contains 'T1100SUM'", 1, uri);

...

sql = "COMPANY = '001001 '";

rc = METASEC_SETAUTH (tc, uri, "Person", "Name User", "Grant", "Read", sql);

...

But by using the table to create a map of information I could still see all the data from the table. Why? Is not it possible to filter the physical tables by their rows? Should we follow aplicacr the other object types (columns)?

[LinusH]

I don't think that in the current release have support for row level security on the table level.

Row level security is available and described by using Information Maps together with a Pooled Workspace Server.

If you need this functionality on the table level, you might need to look for some solution when by using an external database (various RDBMS and SPD Server have support for this).

/Linus

[DanielC]

I do not need to be at the table, looking for the lowest possible level using SAS tables. I searched in the metadata object types of information maps but have not found anything. How to filter information on a map?

[LinusH]

Just search support.saw.com using keywords

row level security information maps

Then you'll find bunch of documentation and papers on the subject. Good luck!

Linus