Is there a way to create bursting report that distribute to the users by there permission right , without maintenance of bursting table
Not sure if this will help you (depending on what is available), just in case if you don't know:
you don't need a burst table to burst the report.
you can create a calculated data item which will generate CAMID for you.
say, you want to burst a report based on country.
now, when you create groups in cognos with the name of country say Australia, Belgium, China etc.. CAMID for them will be CAMID("Australia"), CAMID("Belgium") and CAMID("China"), this we can generate dynamically with expression 'CAMID("' + [].[].[Country Name] + '")'
Note: You need to create appropriate groups in cognos (directory) manually and assign users to that groups