Skip to Content
0

Roles required for sp_monitorconfig

May 08 at 07:11 AM

32

avatar image

Hi,

We are using sp_monitorconfig in our code. According to this doc

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1572/html/sprocs/X22555.htm

we need either manage server privilege or user with sa_role to run it. Providing this is bit risky. Are there any roles with lesser risk that can we can provide to the user since we are trying to create a read only user?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Bret Halford
May 08 at 02:56 PM
0

There is a way to allow other users to run sp_monitor config through a wrapper procedure that uses a hidden password-activated role to temporarily grant sa_role so that they can execute sp_monitorconfig (or whatever else the wrapper procedure is written to let them do) but not anything else.

See http://www.sypron.nl/grant_sa.html for details.

cheers,
-bret

Share
10 |10000 characters needed characters left characters exceeded