RE: detail information of user's grant
I have no idea - but I know how to find out.
SELECT tabname FROM systables WHERE tabid < 99;
Returns 2 of some note.
systabauth and syscolauth
A simple select on these tables might give you a starting point.
HTH
Jo
> -----Original Message-----
> From: andrew [mailto:kuraprok@priv5.onet.pl]
> Sent: 09 February 2000 10:17
> To: informix-list@iiug.org
> Subject: detail information of user's grant
>
>
> Hi,
> How can I obtain information of user's grant for specific
> table? For example
> grant and level of privileges are located in sysusers (I
> suppose), but that
> is information for all database. Is a table, where this
> information is? Or
> the other way to obtain this information?
>
>
> GRANT DELETE, SELECT, UPDATE (customer_num, fname, lname)
> ON customer TO mary, john
>
> TIA
> andrew
>
>
___________________________________________________________________________
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
Sema Group.
If you are not the intended recipient, be advised that you have received this
email in error and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited.
If you have received this email in error please notify the Sema Group
Helpdesk by telephone on +44 (0) 121 627 5600.
___________________________________________________________________________