View previous topic :: View next topic
|
Author |
Message |
jagadeeshkumar
New User
Joined: 17 May 2007 Posts: 11 Location: Chennai, India
|
|
|
|
Hi,
Is there anyway to find the list of all PLAN/Packages which has update previlege for a particular column in a table?
I tried to use the SYSIBM.SYSCOLAUTH and SYSIBM.SYSPLANDEP tables but I am not getting that right.
Can anyone help me if you have the answer?
Thanks in advance. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
list of all PLAN/Packages which has update previlege for a particular column in a table |
Possibly, i misunderstand your question, but update permission is granted on a table not a column and the permission is granted to an authorization id, not a plan/package. |
|
Back to top |
|
|
jagadeeshkumar
New User
Joined: 17 May 2007 Posts: 11 Location: Chennai, India
|
|
|
|
Hi,
I have a scenario, where i should find all the programs which access (select/insert/update/delete) a particular Column in a Db2 table.
I have the query to find the list of programs accessing a given table.
SELECT A.GRANTEE , A.TCREATOR , A. GRANTOR ,
A.SELECTAUTH , A.UPDATEAUTH
FROM SYSIBM.SYSTABAUTH A, SYSIBM.SYSPACKDEP B
WHERE A.STNAME = <table name> AND B.BNAME = <table name>
AND A.GRANTEETYPE = 'P'
AND A.GRANTEE = B.DNAME
AND
( ( A.SELECTAUTH = 'Y')
OR
( A.UPDATEAUTH = 'Y' ) )
ORDER BY A.GRANTEE ;
but I don't have any SQL similar to this to find this detail at the column level.
I believe there must be a way to find this easily instead of scanning through thousands of programs I have. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
but I don't have any SQL similar to this to find this detail at the column level. |
No, there isn't any. . .
Quote: |
I believe there must be a way to find this easily instead of scanning through thousands of programs I have. |
Lots of us believe this would be very useful, but it is not part of standard db2 (as far as i know).
There may be 3rd party products that provide this level of impact analysis, but in several languages using several database products, my teams have scanned the source for reference(s) to the field names. |
|
Back to top |
|
|
|