how to get all privillèges affected to a user!

[la46]

hello,
any help about how to get the privileges affected to a user
(select on tables, delete update...etc)

 

[PHV]

A starting point (SQL code):
SELECT A.grantee,T.tabname,A.tabauth
FROM systables T,systabauth A
WHERE A.tabid=T.tabid AND grantee='UserNameHere'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[la46]

Thanks PHV,
i didn't understand :
table_name su-id---
But now, i think
- s: for select
- u: for update
- d: for delete
- i: for insert

thanks!