access for a User id.

arvind.m · Posted: Wed Mar 25, 2009 10:06 pm

Hi All,
is there any way to know what access does a user id have without counsulting to DBA's.

thanks,

dick scherrer · Posted: Wed Mar 25, 2009 11:35 pm

Hello,

There is typically no reason for developers to know what access a user-id has been granted. . .

If you believe you have a legitimate reason to know, ask your manager to get the info from either the dba or the security people.

Terry Heinze · Posted: Thu Mar 26, 2009 1:55 am

I used to query SYSIBM.SYSTABAUTH a lot to determine who could do what when doing impact analysis. I think most shops allow read authority to that table.