Need help in assigning private reports and dashboards.
Need help in Assigning Private Reports and Dashboards to other user.
There is a User A whose details has been deleted from the database; however, that user is still present in the front end.
We have to migrate the contents of that user to another user.
Please help us with the queries.
For Reports we have used below:
Ran below query to get the list of private reports associated with that user:
reportstatuscode IN (
AND externalaccesscode = 'PERSONAL'
AND ipcreator = 'UserID';
Used below query to make it to Public:
SET ExternalAccessCode = 'CORPORATE',
IpCreator = UserID
WHERE ExternalAccessCode = 'PERSONAL' AND ReportStatusCode = 'OPEN';
Need queries to make Dashboards to Public.
YF : 8.0.6.