View previous topic :: View next topic
|
Author |
Message |
Amsar
New User
Joined: 26 Sep 2008 Posts: 84 Location: Chennai
|
|
|
|
Hi,
Do we have the system table in DB2 to check the read/write access for the user-id for the perticular table.
Thanks,
Amol |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
if You have the need to know, the database/security support groups
will be glad(it depends) to provide You the info |
|
Back to top |
|
|
Amsar
New User
Joined: 26 Sep 2008 Posts: 84 Location: Chennai
|
|
|
|
enrico,
Thanks a lot for suggestion.
Regards,
Amol |
|
Back to top |
|
|
Amsar
New User
Joined: 26 Sep 2008 Posts: 84 Location: Chennai
|
|
|
|
enrico,
I have refer DB2- Manual and found that we have system table
SYSIBM.SYSTABAUTH With columns
GRANTOR
GRANTEE
GRANTEETYPE
DBNAME
SCREATOR
STNAME
TCREATOR
TTNAME - Will be the table name
AUTHHOWGOT
TIMESTAMP
DATEGRANTED
TIMEGRANTED
UPDATECOLS
ALTERAUTH
DELETEAUTH
INDEXAUTH
INSERTAUTH
SELECTAUTH
UPDATEAUTH
IBMREQD
UPDATEAUTH
IBMREQD
GRANTEELOCATION
LOCATION
COLLID
CONTOKEN
CAPTUREAUTH
REFERENCESAUTH
REFCOLS
GRANTEDTS
TRIGGERAUTH
We can get desired information from this table
Regards,
Amol |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
We can get desired information from this table |
Amol,
Yes, it'll give information on the authids/plans/packages and their respective privileges on a table. But the original post was regarding the read/write access for a particular user-id for a table. Do we get the same info from this table? |
|
Back to top |
|
|
Amsar
New User
Joined: 26 Sep 2008 Posts: 84 Location: Chennai
|
|
|
|
Arun,
You have column GRANTEE - Group-name.
You should know the group to which you belong or grantee can be public.
Also you have the columns UPDATECOLS, ALTERAUTH, DELETEAUTH, SELECTAUTH, UPDATEAUTH which will tell you what access your id-has
on that table ( Column =TTNAME )
Regards,
Amol |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
GRANTEE VARCHAR(128) NOT NULL
Authorization ID of the user who holds the privileges or the name of an application plan or package that uses the privileges. PUBLIC for a grant to PUBLIC. PUBLIC followed by an asterisk for a grant to PUBLIC AT ALL LOCATIONS. |
Just curious where do I see the Auth-id for a particular user? |
|
Back to top |
|
|
|