Page 1 of 1

Authorization checking on a DB2 table

PostPosted: Wed Jan 30, 2013 9:24 pm
by chinkump
Trying to access Production tables will trigger a security violation. To avoid this type of situation I want to know how a user can know what type of access is provided to him. If he has read access then only he will browse the table else not(For ex: LISTDSD command for files). Basically I want to know the type of access a user has on a particular table.

Re: Authorization checking on a DB2 table

PostPosted: Wed Jan 30, 2013 9:44 pm
by Akatsukami

Re: Authorization checking on a DB2 table

PostPosted: Wed Jan 30, 2013 11:20 pm
by chinkump
Thanks Akatsukami for your promt response.
In my shop we donot have access to SYSIBM.SYSTABAUTH ......

Please let me know if you have any alternative solution.

Re: Authorization checking on a DB2 table

PostPosted: Wed Jan 30, 2013 11:33 pm
by Akatsukami
chinkump wrote:In my shop we donot have access to SYSIBM.SYSTABAUTH ......

Well, I would recommend that you talk to your DBAs and determine why SELECT access has not been generally granted on this table; it is the authoritative source for other access information. No alternative source has any reliability.

Re: Authorization checking on a DB2 table

PostPosted: Thu Jan 31, 2013 1:35 am
by enrico-sorichetti
trying to determine if <You> have access to a protected resource
is from a security point of view reported and considered a security violation
and cause for lawful termination...

Re: Authorization checking on a DB2 table

PostPosted: Thu Jan 31, 2013 3:31 am
by NicC
Posting in multiple forums at the same time is bad manners. I cannot do anything on the other one so I will lock this one.