topic PermissionCondition in PhysicalTable in SAS Programming

PermissionCondition in PhysicalTable

DanielC — Tue, 08 Nov 2011 09:47:26 GMT

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)?

Re: PermissionCondition in PhysicalTable

LinusH — Tue, 08 Nov 2011 12:03:27 GMT

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

PermissionCondition in PhysicalTable

DanielC — Tue, 08 Nov 2011 12:43:25 GMT

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?

PermissionCondition in PhysicalTable

LinusH — Wed, 09 Nov 2011 22:15:36 GMT

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