DATA Step, Macro, Functions and more

PermissionCondition in PhysicalTable

Reply
Occasional Contributor
Posts: 5

PermissionCondition in PhysicalTable

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

Super User
Posts: 5,429

Re: PermissionCondition in PhysicalTable

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

Data never sleeps
Occasional Contributor
Posts: 5

PermissionCondition in PhysicalTable

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?

Super User
Posts: 5,429

PermissionCondition in PhysicalTable

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

Data never sleeps
Ask a Question
Discussion stats
  • 3 replies
  • 191 views
  • 3 likes
  • 2 in conversation