Solved

Creating view of a table from another user

Posted on 2002-06-03
5
176 Views
Last Modified: 2010-04-01
Hi

i had  a user "sim" representing the main office having following tables
acc_glday,cashes,day_one,day_two andday_sub . for obtaining some consolidated
reports from all branches i had created another user "conso " and created all
the above tables on that user area also.
i am importing data from all branches including the main office  into tables in
user conso.

 i would like to  create a view by the union of tables of user sims and tables
of user conso on the user conso. if i can do taht   it is possible to avoid
importing  data from user sim to user conso and data redundancy can be
eliminated.

please help me for creating such a view of any of above mentioned tables on the
user area conso.


sincerely

rajesh
 
0
Comment
Question by:rajeshnalankal
  • 3
5 Comments
 
LVL 4

Expert Comment

by:pellep
ID: 7053631
what database?
0
 
LVL 4

Expert Comment

by:pellep
ID: 7053632
that is, what type of database system are you using?
0
 

Author Comment

by:rajeshnalankal
ID: 7054074
Hi

sorry for not mentioning full details

i am using oracle database

rajesh
0
 
LVL 4

Expert Comment

by:pellep
ID: 7054176
maybe you should ask this question in the oracle TA instead.
0
 
LVL 5

Accepted Solution

by:
kelfink earned 100 total points
ID: 7055069
Oracle can define both VIEWs and SYNONYMs.

The VIEW you ask about is possible.  Sounds like you want to join tables between the two users.

For example:

CREATE VIEW V_SOME_TABLE_JOINED
SELECT * FROM  SIM.SOMETABLE a, CONSO.MYTABLE b
WHERE a.id = b.some_id ;

Remember that SIM must grant permission to CONSO to read his tables...

SIM>  GRANT SELECT ON SOMETABLE TO CONSO;



0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article demonstrates probably the easiest way to configure domain-wide tier isolation within Active Directory. If you do not know tier isolation read https://technet.microsoft.com/en-us/windows-server-docs/security/securing-privileged-access/s…
Arrow Electronics was searching for a KVM  (Keyboard/Video/Mouse) switch that could display on one single monitor the current status of all units being tested on the rack.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question