<div>
<div class="content wysiwyg-content">
I guess I can do it by joining SYS tables, but I was expecting to find something like sp_iqhelpprotect.<br />
<br />
Is there Sybase supplied a way to show grants for various types of objects (or for individual objects)?<br />
<br />
If not, can anyone point me to a code snippet to do this?<br />
<br />
Thanks in advance<br />
Ben
</div>
</div>


I guess I can do it by joining SYS tables, but I was expecting to find something like sp_iqhelpprotect.

Is there Sybase supplied a way to show grants for various types of objects (or for individual objects)?

If not, can anyone point me to a code snippet to do this?

Thanks in advance
Ben

How can I show grants in Sybase IQ? (for one or all objects)

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.