how to revoke select rights automatically from a user

[SybDBA]

Hi All,

How do, I revoke select rights after specific time in SAP IQ ?

For e.g,

like If my requirement is to grant select to a specific user for 2 days only , so what should I do , instead of manually revoking the rights.

Please, inputs are appreciated.

Regards

[SybDBA]

Thanks Tayeb, if you can help me to write an script/event as such, it will be more helpful for me.

Regards

[tayeb_hadjou]

Currently, Grant/object Level IQ syntax does not contain duration option. Alternatively, you can try manage that using IQ Event.