Set Permissions dynamically

Remco

Hi,

As you (perhaps) all know a report as a property Permissions to give a database object extra permission to perform some operations on one or more tables. The operations can be to read, insert, modify and delete data.

Is is possible to fill these permissions dynamically, for instance, based on data in a table? If a specific record which refers to a table in Navision exists give extra permissions to this table.

Thanx

Tomas

I doubt it's possible to do that automatically.

However, you could run report with SUPER role and code coverage running. Then, at least you would have a list of all tables that reports was trying to work with. And then, you could add these tables into report's permissions manually.

Any other ideas?