Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
la46

la46

Programmer
Mar 15, 2004
26
MA
hello,
any help about how to get the privileges affected to a user
(select on tables, delete update...etc)
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
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!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

daYorkie
  • Locked
  • Question
How many UNIONs can i use in a single query?
Replies
2
Views
377
daYorkie
daYorkie
jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
370
jamescpp
jamescpp
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
360
arunkumar.ceg
arunkumar.ceg
kray4660
  • Locked
  • Question
Trying to do a count on logged in users
Replies
1
Views
364
kray4660
kray4660
chongseng
  • Locked
  • Question
How to using informix 4gl send email?
Replies
1
Views
257
chongseng
chongseng

Part and Inventory Search

Sponsor

Back
Top