Authorization checking on a DB2 table



IBM's flagship relational database management system

Authorization checking on a DB2 table

Postby chinkump » Wed Jan 30, 2013 9:24 pm

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.
chinkump
 
Posts: 26
Joined: Fri Jan 20, 2012 10:48 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Authorization checking on a DB2 table

Postby Akatsukami » Wed Jan 30, 2013 9:44 pm

"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Authorization checking on a DB2 table

Postby chinkump » Wed Jan 30, 2013 11:20 pm

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.
chinkump
 
Posts: 26
Joined: Fri Jan 20, 2012 10:48 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Authorization checking on a DB2 table

Postby Akatsukami » Wed Jan 30, 2013 11:33 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: Authorization checking on a DB2 table

Postby enrico-sorichetti » Thu Jan 31, 2013 1:35 am

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...
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Authorization checking on a DB2 table

Postby NicC » Thu Jan 31, 2013 3:31 am

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post