how to get all privillèges affected to a user!
how to get all privillèges affected to a user!
(OP)
hello,
any help about how to get the privileges affected to a user
(select on tables, delete update...etc)
any help about how to get the privileges affected to a user
(select on tables, delete update...etc)
RE: how to get all privillèges affected to a user!
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: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: how to get all privillèges affected to a user!
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!