How to manually re-grant privileges to the 'foglight' DB user account?
How to get the grant privileges script from the Foglight UI?
To get the grant privileges script go to: "Administration | Cartridges | Components for Download".
Find "DB_Oracle_Grant_Permission_Script" and download it.
Transfer the file to the database server and run it there via SQL*Plus. The user who runs the script needs SYSDBA privileges. The script request the Foglight DB user name and once you entered it, the needed privileges will be granted. Instead of SQL*Plus you can use any other DB Administration tool, for example Toad.