If any new user is created and given "schedule report" privilege,
instead of logging to bipublisher portal with the user's id and scheduling individual report I want to have a pl/sql package which when fired, if finds any new user should run those reports and save output for the user.
For these I should call the bipublisher report in pl/sql through scheduler schema, set parameter values, provide run_interval, output_format etc.
Please let me know if this is possible and also give example code.
This is urgent requirement. Please reply ASAP.
Thanks and Regards.