| View previous topic :: View next topic |
| Author |
Message |
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
 Posted: Tue Sep 14, 2010 9:45 am Post subject: alias stored in which catalog table |
 |
|
Members,
I would like to know if we create an Alias for a table , which catalog table DB2 creates an entry for , how can we check for aliases created. |
|
| Back to top |
|
 |
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
|
| Back to top |
|
|
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
| Posted: Mon Sep 20, 2010 10:46 am Post subject: |
|
|
| We have a alias created for a table.I want to know what all are the users who can access the alias. |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
|
| Back to top |
|
|
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
| Posted: Mon Sep 20, 2010 9:43 pm Post subject: |
|
|
Dick,
I checked for SYSIBM.SYSTABAUTH table for all the column definations but I could not find any alias information. I see that this catalog table records the privileges that users hold on tables and views but does not mention anything for aliases. Am I am missing something here. |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Tue Sep 21, 2010 1:32 am Post subject: |
|
|
well, maybe someone else knows and will post.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
| Posted: Tue Sep 21, 2010 5:20 am Post subject: |
|
|
| Members can anybody help me further. |
|
| Back to top |
|
|
Sqlcode
Intermediate
Joined: 15 Dec 2006
Posts: 157
Topics: 38
|
| Posted: Tue Sep 21, 2010 8:59 am Post subject: Re: alias stored in which catalog table |
|
|
| yadav2005 wrote: | Members,
I would like to know if we create an Alias for a table , which catalog table DB2 creates an entry for , how can we check for aliases created. |
Alias(as the name suggests) is another logical name for table object. It inherits ALL the attributes of the original object. Seems like you are mixing VIEW with ALIAS because VIEWS can have different privileges than actual physical table privileges. How do you get all the users having access to particular table? The same users should have access to ALIAS as well. But to answer your question, AFAIK, no table stores access information for ALIAS.
At my shop, usually ALIAS is used in Application programs only and access is that of the owner of the plan or package.
See if this link helps you ...
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sql_createalias.htm
Let us know if this helps or if you still have specific question.
Thanks, |
|
| Back to top |
|
|
yadav2005
Intermediate
Joined: 10 Jan 2005
Posts: 348
Topics: 144
|
| Posted: Tue Sep 21, 2010 10:18 am Post subject: |
|
|
| Thanks a lot your explanation helps me a lot. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
