Application Express :: Cannot Read Table In Other Schema Even With Qualifier

Jun 8, 2012

I had a situation last year where I could not login as myself or see any objects in my schema. Some code using APEX methods to create a new APEX user, and it finally worked.

The new user, ADMINUSERS suddenly had its password expire and I could not reset it, so I repeated last years’ effort but this time nothing worked.

Now I have a problem where I cannot even read a table if it is in another schema, even if I use the schema name as a qualifier. This happens even in SQL plus, except when I login as System I can read tables in other schemas if I prefix the table name with the schema and a dot. But this does not work with other users, even though I have granted the other users the role of dba.

View 17 Replies


ADVERTISEMENT

Application Express :: Pass Header Variable From OAM To Apex And Read It In Application?

Mar 4, 2013

We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.

The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups

We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname

The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME

But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;

The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.

View 1 Replies View Related

Application Express :: Delete Read Only Application From A Workspace?

Oct 12, 2013

What can I do if I want to delete read only application from a workspace?

View 1 Replies View Related

Application Express :: Set Value For Read-only Field?

Sep 22, 2012

I have a form that based on a table,

Col1: text field
Col2: text field with Disabled =Yes and Save session state = Yes

I create a dynamic action on Col1 to set value for Col2, when I submit page an error raised: Session state protection violation

visit: [URL]...

My purpose is: Col2 is set value by Col1 via Dynamic action, and is read-only, user cannot modify.

View 7 Replies View Related

Application Express :: Text Areas In 4.2.2 - Can't Be Read Dynamically

Sep 3, 2013

i encountered a big problem after upgrading Apex from 4.1 to 4.2.2. On an application page there is a Text Area which will be read and processed after clicking a button. I didn't want a refresh of the page and did it with a dynamic action.All this worked like a charm with 4.1. Since the upgrade, the value of the Text Area is always returned as null while processing the dynamic action, but the value is filled by the user!When i change the type of the Element to Rich Text Area everything works fine, but i don't want this because i don't want HTML in the corresponding table. Is this a bug? How can i workaround it? 

View 10 Replies View Related

Application Express :: Select List Read Only / Or Display Only

Sep 3, 2012

I have Select list itemS based on Lookup tables. When the form in Edit mode, I want to prevent the end user from changing the value of these Select list items. How can I accomplish this ??? **If I change the type of the item to Display only, then it will show the returned value of the Select list.

View 1 Replies View Related

Application Express :: Conditional Read Only That Saves To Database?

Nov 27, 2012

I have an item that does not save to the database.it is conditional read only based on the value in another column, when it is not read only it displays as a Select list.. then whatever is chosen triggers a dynamic action that sets other items.so setting it as a display only is not an option.

after upgrading from 4.0 to apex 4.2 this gives error:   Session state protection violation: This may be caused by manual alteration of protected page...

the only workaround I have found is to set the Read Only to none, then create a dynamic action that conditionally sets the field to disabled..This works, but my problem with it is that it looks different than the read only..read only was Black Text and no textbox..disabled is a text box with greyed out text that is hard to read for some of the users..

View 4 Replies View Related

Application Express :: Change Read Only Condition From Always To None On Real Time

Sep 4, 2012

Can we change the condition of an item from always to none on the real time ? How ?

View 3 Replies View Related

Application Express :: Imports Apex Applications Without Schema / Sys Passwords

Jul 11, 2013

we got more that 50 apex apps, Deploying it through apex console is becoming pain.we won't get sys or schema passwords. etc  as databases are controlled by DBA's,  We only get apex_public_user password, internal, workspace admin passwords.If there is any need of schema association for any applications/workspace, We login to internal workspace and map schema to workspace. I read couple of blogs which discussed about automating the deployments through sqlplusconnecting as sys or schema user,  will not work for us. Want to know if there is anyway I can import deployments without logging into workspace. We already have workspaces and applications. The deployments will be for updating existing application or deploying new application in existing workspaces. Oracle Application Express 4.1.

View 1 Replies View Related

Read Access To Schema

Oct 12, 2012

Below is the request i have received from a user -

" Can you setup user <usernmae> in <database>S to have read only access to <applicationname> (CHADBA, CHAS, EMI and SVCM schemas)"

Steps I have followed -

create user <usernmae> identified by password default tablespace USERS temporary tablespace TEMPL;

Grant PRODUCEBILL to <username>;
Grant REPORTING to <username>;
Grant PAYMENT to <username>;
Grant CONNECT to <username>;

My question is as user has request for read only access to specific schemas, so how do I validate them?

View 11 Replies View Related

Application Express :: Increasing Schema Size Without Raising Service Request?

Jul 13, 2012

How can in increase the allocated space for a schema in Apex Admin section?

I know you can set this when creating a schema alongsite a workspace and looks like the only way to do it is via raising a service request for more space and loggin in as ADMIN and approving it (in increments of 500MB).

View 4 Replies View Related

Application Express :: How To Make Use Of SSO Login Credentials Of Oracle In Authentication Schema

Jul 16, 2013

I am using SSO login for Authorizations. Would like make use of SSO for creating authentication schema. My main requirement is to assign privilege based on users using SSO loging.

View 0 Replies View Related

Mobile Server :: How To Write Client Mobile Application - Read Publication Or Sqlite Table

Aug 16, 2012

Trying to learn about Oracle Database Mobile Server.Installed the server, installed the client on WIN 32, created a publication and successfully synchronized.Now need to write a client application for mobile users.

Qs 1) Can I write a simple JSP that reads a table from device SQLITE database?or, the JSP needs to read off a subscrption?If it needs a subscription as the source, then how do I mention it in the JSP?

2) example of such a Client program

View 0 Replies View Related

Client Tools :: How To Create A Table In Another Schema As In Existing Schema

Apr 26, 2010

I would like to create a table in another schema(CBF) as already exist in my schema(TLC) without data but related indexes,synonyms and grants should be include.

How could I do this without using export import. I am using TOAD 9.0.1.

View 10 Replies View Related

Export/Import/SQL Loader :: Imp Records Of One Schema Into Another Schema Of Same Table

Nov 3, 2012

I had done following steps,

schemas(toy,toys)

1) i open the session of toy schema

First i taken backup of table

create table bck20121103_himan as select * from himan;

Backup table is created.

After taking the Backup table

delete himan;(deleting the records)

2) i log in to another session(toys)

exp toys/toys@orcl file=20121103TOYs.DMP TABLES=(HIMAN) /* Particular table is taken*/

3) i log in to toy schema

imp toy/toy@orcl file=<dump file name> TABLES=(HIMAN) INDEXES=N IGNORE=Y

i tried the above statement it taken so much of time..

Later i tried

I log in to toy session

i rename the table with other name.

later i imported

imp toy/toy@orcl file=<dump file name> TABLES=(HIMAN) IGNORE=Y FULL=Y

it's successfully imported.

View 3 Replies View Related

Application Express :: Insert Into History Table When Update Action Is Performed On Tabular Form View Or Table

Aug 24, 2013

My scenario is I need to insert into History table when a record is been updated into a tabular form(insert the updated record along with the additional columns Action_by,Action_type(Like Update or delete) and Action Date Into History table i.e History table contains all the records as the main table which is been visible in tabular form along with these additional columns ...Action_by,action_type and action_date.

So now i dont want to create a befor/after update trigger on base table rather i would like to create a generic procedure which will insert the updated record into history table taking the page alias and pade ID as the parameters(GENERIC procedure is nothing but whcih applies to all the tabular forms(Tables) contained int he application ).

View 2 Replies View Related

Forms :: How To Read Application URL Runtime

Apr 21, 2009

Is it possible to read the application URL while running the application

[URL]

Above is my URL i need to read i and t hold it on a variable at runtime

View 3 Replies View Related

Forms :: Read Data From Table And Insert To Another Table With A Cursor?

Feb 20, 2013

I have a table with a BLOB column ;

I want read data from table and insert to another table with a cursor

My code is :

procedure read_data is
cursor get_data is
select id,image from picture1;
id1 number;
pic blob;
begin
open get_data;

[code]....

when I run form , error FRM-40734 occurred

error in line " fetch .... "

View 1 Replies View Related

Application Express :: Form On A Table With Report

Apr 24, 2013

I have one question. Is possible export form to CSV (or PDF) for example? If it is, what is the process?

View 0 Replies View Related

Application Express :: Upload Data From CSV / XLS To Table

Jul 25, 2013

I am new to the Upload data from excel to Table..... how to implement on this.....I need code for UpLoad CSV/XLS Files to the Table ....Table name T_UPLOAD have contains 40 columns....

View 3 Replies View Related

Application Express :: Import Xml File Into A Table

Dec 13, 2012

I'm trying to upload a xml file into a table but I don't know which separator do I have to select to show the columns well. I does not recognize the columns.

View 5 Replies View Related

Application Express :: Pivot Table Layout?

Nov 5, 2012

in my application i have a requirement as follows

1) column 1 indicator
2) column 2 important.

and the other columns are target actual and current year, previous year and next year.the layout should be in pivot table lay out as follows here the three columns will be saved dynamically as 2012,2011,2013 and the respecitive percentage in target and actual column

current_year previous_year next_year
target 10% 12% 5%
actual 5% 8% 5%

View 1 Replies View Related

Application Express :: Unloading Data From A Table

Mar 21, 2013

I'm trying to unload data from a table, so i go to SQL Workshop > Utilities > Data Workshop > Data Unload to Text, i select my table, select the columns, give the condition to unload the data of the last month (between sysdate-28 and sysdate), then i select the comma separator, including the column names, and finally press "Unload Data"...the file is downloaded correctly, but when i open the file, the data is not ordered as i expected.

View 1 Replies View Related

Application Express :: Formatting A Table Without Headings

Apr 3, 2013

I want to make a report which is formated (rebuilding an older tool in Access).

So on the one hand I need some formattings which I implemented with the search bar in the interavtive report. (content of the first column is the heading for a table with the rest of the content of all rows which have the sam content in the first column) On the other hand I don't want to show the headings of the columns, what I solved with the classic report(report attributes/ column attributes: none).
Is the a solution to match these two requirements in one report?

View 4 Replies View Related

Application Express :: Page Validation Against Table Definition?

Apr 29, 2013

I am trying to apply page validations on a tabular form. The form allows users to update data in a database table. I have created some validations such as "column x must not be null" etc and on submit, the error message appears and the relevant cells are highlighted in red. All ok so far.

However, for the primary key, I am relying on the table definitions in the Oracle database to not allow duplicate row entries. When a user tries to enter a duplicate row the error message appears but the relevant row / cells are not highlighted, just the row number is given. In a table with many rows this is a bit annoying.

Is there anyway to get the cells to highlight in red for such circumstances or do I need to create the primary keys within APEX itself?

APEX 4.2.1.00.08

View 0 Replies View Related

Application Express :: Automatic Update Of Collection And Table?

Oct 29, 2013

I am trying to update a collection and a table.I got some example code and installed on oracle.com, but I just can't seem to get it to work.I always get an errorORA-20001: Current version of data in database has changed since user initiated update process.I think the problem lies with comparing the checksums, but I cannot spot the mistake 

View 2 Replies View Related

Application Express :: Show Count From Another Table In A Report

May 29, 2013

I am using Apex 3.2...I have the following sql in a report

select
a.jobid jobid,
a.jobid related_jobs,
to_char(a.startdate, 'dd.mm.yyyy hh24:mi:ss') startdate,
to_char(a.enddate, 'dd.mm.yyyy hh24:mi:ss') enddate

from jobs aI would like to show a count from another table where the jobid = jobid from the above sql.The problem is I don't know how to refer to the jobid in my extra sql.Here is my extra sql for the new count column.

(select count(1)
from jobs a, loghead b, dba_scheduler_job_run_details c
where a.logid = b.logid
and b.session_id(+) = c.session_id
and a.jobid = :P3_JOBID) no_of_related_jobs.

This will not work because :P3_JOBID is a page item.I have also tried #JOBID#, but got en error, as it was not recognised.

View 1 Replies View Related

Application Express :: Download Link On Column From Another Table?

Apr 1, 2013

I'm a APEX newbie using APEX 4.1. I have a table with engineering drawing information (drawing number, title, revision, etc.) and another table with the corresponding drawing files (pdfs stored as blobs where the filename is the drawing number with a pdf extension). The user wants to search for a particular drawing by drawing number from the drawing info table and if the drawing number exists in the drawing files table the drawing number will also be a download link for the file, if the drawing number doesn't exist in the drawing files table than the drawing number will display as plain text (not as a download link).

View 1 Replies View Related

Application Express :: Upload CSV Files To Table Using 3.2 Version

Jul 30, 2013

Using Apex 3.2 version , Need to  Upload .CSV Files  to the Table (T_UPLOAD),

View 11 Replies View Related

Application Express :: How To Insert Contents Of CSV File In Table

Sep 16, 2013

I'm starting with APEX, I would like to know how to insert the contents of a file. Csv in a table, how to map a file to a table, how to insert file contents. Xls in a table.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved