SP_HAS_ROLE Function [System]
Returns an integer value indicating whether the invoking user has been granted a specified system privilege or user-defined role. When used for privilege checking within user-defined stored procedures, SP_HAS_ROLE returns an error message when a user fails a privilege check.
sp_iqaddlogin Procedure
Adds a new SAP Sybase IQ user account to the specified login policy.
sp_iqconnection Procedure
Shows information about connections and versions, including which users are using temporary dbspace, which users are keeping versions alive, what the connections are doing inside SAP Sybase IQ, connection status, database version status, and so on.
sp_iqdbspaceinfo Procedure
Displays the size of each object and subobject used in the specified table. Not supported for RLV dbspaces.
sp_iqdbspaceobjectinfo Procedure
Lists objects and subobjects of type table (including columns, indexes, metadata, primary keys, unique constraints, foreign keys, and partitions) for a given dbspace. Not supported for RLV dbspaces.
sp_iqemptyfile Procedure
Empties a dbfile and moves the objects in the dbfile to another available read-write dbfile in the same dbspace. Not available for files in an RLV dbspace.
sp_iqestdbspaces Procedure
Estimates the number and size of dbspaces needed for a given total index size.
sp_iqfile Procedure
Displays detailed information about each dbfile in a dbspace.
sp_iqmodifyadmin Procedure
Sets an option on a named login policy to a certain value. If no login policy is specified, the option is set on the root policy. In a multiplex, sp_iqmodifyadmin takes an optional parameter that is the multiplex server name.
sp_iqobjectinfo Procedure
Returns partitions and dbspace assignments of database objects and subobjects.
sp_iqspaceused Procedure
Shows information about space available and space used in the IQ store, IQ temporary store, RLV store, and IQ global and local shared temporary stores.
sp_iqsysmon Procedure
Monitors multiple components of SAP Sybase IQ, including the management of buffer cache, memory, threads, locks, I/O functions, and CPU utilization.
sp_objectpermission System Procedure
Generates a report on object privileges granted to the specified role, or user name, or the object privileges granted on the specified object or dbspace.
sp_sys_priv_role_info System Procedure
Generates a report to map a system privilege to the corresponding system role. A single row is returned for each system privilege.