Monitors counters Privileges

[unknown]

Hi Guys,

Does anybody knows how to configure a sybase's user to allow
a sitescope performance monitor application can read
sysbase´s monitor counters using a login role without
SYSADMIN rights.

Any idea or suggestion is welcome.

Thanks.

[Mark A. Parsons]

I'm assuming by 'monitor counters' you're referring to the master..sysmonitors table (and the periodic update/refresh of
the data in said table). If so, a couple ideas come to mind ...

- have a login with sa_role periodically refresh master..sysmonitors and then dump the data into a staging table (w/
additional 'sampling datetime' column) that your sitescope login can access

- use CIS and proxies to emulate sa_role access to master..sysmonitors; to get you started I'd suggest taking a look at
Rob's work (http://www.sypron.nl/grant_sa.html) for ideas

NOTE: For directions on how to refresh the contents of master..sysmonitors I'd suggest taking a look at the source code
for the sp_sysmon stored proc.

NOTE: I don't have any experience with sitescope so I'm assuming you can get sitescope to connect to an ASE dataserver
and run queries and/or stored procs.

Post by unknown
Hi Guys,
Does anybody knows how to configure a sybase's user to allow
a sitescope performance monitor application can read
sysbase´s monitor counters using a login role without
SYSADMIN rights.
Any idea or suggestion is welcome.
Thanks.