Home » Applications » Oracle Fusion Apps & E-Business Suite » creating view based on an existing view in Oracle Clinical
creating view based on an existing view in Oracle Clinical [message #94823] Wed, 03 April 2002 05:55 Go to next message
Sonal
Messages: 3
Registered: October 2001
Junior Member
Can a view be created in Oracle Clinical based on another view? If so are special privileges required?
Re: creating view based on an existing view in Oracle Clinical [message #94935 is a reply to message #94823] Tue, 18 June 2002 20:17 Go to previous message
Chris Huang
Messages: 1
Registered: June 2002
Junior Member
If you are trying to create a view against an Oracle Clinical extract view, then YES, there are two ways. The first would be to create the view in the study access account, but you need to first grant create session to the study access account as system or rxc_maa. The second option would be to grant a personal account rxclin_read and "select any table" privilege.
Previous Topic: Default passwords within Oracle ERP
Next Topic: Re: Oracle financial consultant training course
Goto Forum:
  


Current Time: Sun Jun 20 16:31:55 CDT 2021