MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Aliases and Synonyms

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
kalidasv
Beginner


Joined: 05 Mar 2009
Posts: 13
Topics: 8

PostPosted: Thu Apr 16, 2009 3:59 pm    Post subject: Aliases and Synonyms Reply with quote

I read from a DB2 book that an Alias is available to all users but Synonym is private to the who user who creates it. Aliases are stored in SYSTABLES and Synonyms are stored in SYSSYNONYMS. I would like to know how DB2 prevents an user from using Synonym that is created by another user.
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Thu Apr 16, 2009 6:37 pm    Post subject: Reply with quote

how about CREATOR from sysynonyms (as well as the synonym) cross referenced (joined) to SYSIBM.SYSDBAUTH table.

that is a guess. as a developer never really cared how db2 enforces policies, just knew that it did.

to get the real answer, ask a DBA.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12380
Topics: 75
Location: San Jose

PostPosted: Thu Apr 16, 2009 6:54 pm    Post subject: Reply with quote

kalidasv,

By Default synonyms are ONLY accessible to the owner who created them.

Kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
kalidasv
Beginner


Joined: 05 Mar 2009
Posts: 13
Topics: 8

PostPosted: Fri Apr 17, 2009 2:54 am    Post subject: Aliases and Synonyms Reply with quote

Dick and Kolusu,

I very much appreciate your responses.

Regards
Kalidas
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group