To create the Foglight user
1). Create a Foglight login account in the Sybase database. For example, svcfgadmin
sp_addlogin 'svcfgadmin' , 'foglight' , sybsystemprocs
go
2).Grant the mon_role role to the account
grant role mon_role to svcfgadmin
go
3). Run the rapsAdmin.sql script as the sa user.
4). Run the sp_fgl_adduser procedure as the sa user. For example:
sp_fgl_adduser 'svcfgadmin' , 'foglightGroup'
go
The above command creates a group named foglightGroup and a user named svcfgadmin in each database, and in the sybsystemprocs database, it grants the permission for creating procedures to that user account.
5). Restart the agent
If there are any errors in the log file, then stop the agent and delete the fgl_ tables from the temp database manually in case the tables have been created with the wrong schema
drop table fgl_blocker_SQLText
go
drop table fgl_missed_SQLTest
go
drop table fgl_processes
go
drop table fgl_sy2_deltatable
go
drop table fgl_waitinfo
go
Then restart the agent again
