You may create groups that grant permissions for various related stored procedures, for example:
Group name |
Grant authority |
Grant EXECUTE permission on stored procedures |
|---|---|---|
OPERATOR_GRP |
OPERATOR |
sp_iqbackupdetails, sp_iqbackupsummary, sp_iqconnection, and sp_iqsysmon |
SPACEADMIN_GRP |
SPACE ADMIN |
sp_iqdbspace, sp_iqdbspaceinfo, sp_iqdbspaceobjectinfo, sp_iqemptyfile, sp_iqestdbspaces, sp_iqfile, sp_iqobjectinfo, and sp_iqspaceused |
For a multiplex example, see Using Sybase IQ Multiplex.