Authorization checking on a DB2 table
Previous topic • Next topic • 6 posts
• Page 1 of 1
Authorization checking on a DB2 table
by 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.
Re: Authorization checking on a DB2 table
by 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
-
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
by 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.
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
by 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
-
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
by 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...
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
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: 3006
- Joined: Fri Apr 18, 2008 11:25 pm
- Has thanked: 0 time
- Been thanked: 165 times
Re: Authorization checking on a DB2 table
by 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
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
Previous topic • Next topic • 6 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- BIND AUTHORIZATION ERROR
by RC=0 » Thu Jan 22, 2009 4:56 pm - 1 Replies
- 6742 Views
- Last post by dick scherrer
Fri Jan 23, 2009 12:47 am
- BIND AUTHORIZATION ERROR
-
- Converting multi table tablespaces into uni table tablespace
by suresh_48 » Mon Aug 15, 2011 7:06 pm - 2 Replies
- 3049 Views
- Last post by suresh48
Tue Aug 16, 2011 12:51 pm
- Converting multi table tablespaces into uni table tablespace
-
- FETCHING ROWS FROM ONE TABLE TO OTHER TABLE USING CURSORS
by avvarycobol » Wed Mar 23, 2011 8:05 pm - 7 Replies
- 4114 Views
- Last post by The Butcher
Sun Mar 27, 2011 8:36 pm
- FETCHING ROWS FROM ONE TABLE TO OTHER TABLE USING CURSORS
-
- First rows in Table A- process and write it to table
by raulravi » Thu Dec 13, 2012 4:48 pm - 6 Replies
- 2879 Views
- Last post by Akatsukami
Tue Dec 18, 2012 4:45 pm
- First rows in Table A- process and write it to table
-
- Parent Table and Child Table
1, 2by chetan_007 » Mon Jun 22, 2009 10:40 pm - 10 Replies
- 10620 Views
- Last post by Robert Sample
Tue Mar 09, 2010 9:42 pm
- Parent Table and Child Table