Application Express :: Restricting Access To Users
Dec 22, 2012 restrict access to page or component for particular user. when that user login , restricted page should not be visible to the user..
APEX Verison :4.2
ADVERTISEMENT
Application Express :: How To Access Data Of All Users In A Page
Jan 23, 2013I have installed APEX on my local machine, created a workspace, and added a few users with roles.
I am creating an application, similar to a Library app, where I have a table that stores Books information (BOOK_ID, BOOK_NAME, etc). I'd like to create another table BOOK_USER with two columns, BOOK_ID and USER_ID. BOOK_ID would refer to the BOOKS table, and I want USER_ID to refer to the table that stores user details of the workspace that I am using. The data entry would happen from a page that has two LOVs, one for book name (using BOOK_ID as the value) and another for user name (USER_ID, or whatever field APEX uses to store user's ID). Can I do that in APEX? I've found ways to access and authenticate a user for a page, but how to get data of all users in the workspace? In other words, how to get all usernames in a LOV?
Security :: Restricting User Access?
Oct 17, 2010The application user owns the application schema which owns all the database objects in this schema. Now 50 of our developers need access to this application schema but giving away the password for the application user is risk as "Drop user application cascade" and wipe off all the objects. The option i have is to create 50 separate users with tablespace as application and grant all rights to application schema.
View 9 Replies View RelatedApplication Express :: ORA-24247 / Network Access Denied By Access Control List
Apr 5, 2013When I invoke SOAP Web-Service using APEX_WEB_SERVICE.MAKE_REQUEST, then I'm able to get response from web-service. However all German character are replaced by JUNK data. However data is coming fine when I test web-services using SOAP UI.
I tried to invoke web-service using UTL_HTTP. However when I use UTL_HTTP, then I'm getting following error.
ORA-24247: network access denied by access control list
<li> Why German characters are replaced by Junk data while invoking web-service from APEX, while it's working fine from SOAP UI
<li> When I can access web-service successfully using APEX_WEB_SERVICE, then why it's throwing ORA-24247 error when I call using UTL_HTTP?
DB: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
APEX: 4.0.2.00.07
Web-Server: EPG
SELECT * FROM NLS_DATABASE_PARAMETERS;
[code]...
Security :: Restricting DBA Access To All Data Of The Tables (Encryption / Others)
Nov 4, 2012We have got a new requirement wherein, The customer wanted the DBA Vendor (US) NOT to access the confidential information (ALL Columns) in the DB tables of PRODUCTION database. This is for few applications to comply with with export control rules. The thin support by Customer DBA will be allowed to access the Data, if required .
1) Web Based Interface ?.
2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)
3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)
4) Standard Tools / Utilities / Others ??.
Technologies are Oracle ,SQL
Application Express :: Display List Of All Users On Page / Accessing Or Using Application
Mar 23, 2013i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies View RelatedApplication Express :: Application Locking - Force Logout All Current Users And Prevent Login
Jun 12, 2012I have an application that I'd like to prevent activity in after a certain time of day, say 3pm. Is there any way I can force logout of all current users and then prevent re-login until 9am the next day (short of deleting all of their login credentials and then recreating them the next morning)?
View 7 Replies View RelatedApplication Express :: Adding Users To A Database?
Nov 7, 2013I have an application that I am adding users to as end users. How do I assign them to a particular application? I am using Apex 4.1, Oracle 11g.
View 10 Replies View RelatedApplication Express :: Implementing DMZ For Intranet And Internet Users
Aug 28, 2012We are planning to use an Application Express application for intranet and internet users. We want to implement a DMZ configuration for this application.
Is there any good guide to implement it?, we want to use Oracle Http Server to access Oracle Application Express.
Application Express :: Creating Functionality For Changing Users Password
Mar 12, 2013I'm trying to create a functionality on my application that lets the user change their password whenever they want or when the password gets expired.
But to do that, first I need a Branch to the page "Password Change" whenever the login procedure returns "Password Expire", but when the user has an expired password he can't access none of the pages of the application.
My other problem is:
Even if I can get the user to be redirect to the "Password Change" page, I would need a function that validate his current expired password, because in order to alter his own, he would need to inform his current password and the new one he desires. If I was using Apex Authentication that would be very easy I think, but I'm obligate to use Database Account Authentication.
Application Express :: How To Access Other Schemas In Application
Oct 11, 2012I just installed Apex and want to create an application that accesses data in a non-Apex schema. However, when I create an application I can't see objects in other schemas. I tried specifying the schema and tablename (e.g. apps.gl_je_headers) but that didn't work. I can only see objects in the APEX schema. How do I reference other schemas when I create an application?
View 1 Replies View RelatedApplication Express :: Cannot Access Applet
Jun 18, 2012i've followed previous threads on this issue, but still cannot get my applet to run from apex. below is the source for my page:
<html>
<head>
<title> LAND MAP </title>
</head>
<body>
<APPLET
id="LandApplet2"
CODE="LandApplet2.class"
width="700" height="300">
[code]....
Application Express :: Raise Warning When Password Due To Expire - Oracle Database Users
Aug 23, 2012Using Apex 4.1 and custom authentication based on Oracle Database users.
I want to be able to show a warning immediately after a user logs in if their password is due to expire in xx days. Oracle raises a warning (ORA-28002) but I don't know how to handle that from the standard Apex login page.
Application Express :: Unable To Start Or Access 4.2.1
Feb 4, 2013I installed Apex 4.2.1 and now m not able to start the page .
[URL] ...
or
[URL] ....
or
[URL] ....
and only see a blank page.
Application Express :: How To Access User Information
Jan 2, 2013 I am new to Oracle APEX, and have a few questions regarding the user information.
I've created a new workspace on my local APEX installation, created some users in the workspace, and divided them into roles as "Managers" and "Employees". I am the only Dev and Admin of the workspace, and the users (Managers and Employees) I have created are viewers.
I'd like to create database tables in the workspace where some field would refer to the user ID of the created user as a foreign key, and their role. Similarly, I'd like to create pages where a particular region is displayed only if the logged in user is a "Manager". How can I access the user data and the role data using SQL?
I see following tables in my workspace, so which table contains the user information:
APEX$_ACL
APEX$_WS_FILES
APEX$_WS_HISTORY
APEX$_WS_LINKS
APEX$_WS_NOTES
[Code]....
Application Express :: Store Encrypted Numeric Value And Make Unencrypted Value Visible To Just Some Users In Apex
Jul 3, 2013I'm looking for a way to store an encypted numeric value in one field in a table (so that it appears encrypted even to a DBA) and to display the unencypted value in Apex forms and interactive reports for some users but not others.
View 4 Replies View RelatedSelect Access To Users
May 2, 2013Are you aware of any "Best Practice Document" to grant select accesses to users on databases. These users are developers which select data out of database for the investigation and application bug fix.
From time to time user want more and more access to different tables so that they can do investigation properly.
Users With Direct Access To Tables
Dec 11, 2012I need to find out which users have direct access to tables, not through the roles.
Is dba_tab_privs the right table to query or table_privileges is the correct one.
What is the difference between these two.
I have gone through the documentation but I am still not clear about the difference between them.
Let me know whatever your thoughts are on this.
ISQL*Plus :: How To Limit Access To Few Users
Oct 29, 2013I would like to know if it's possible to limit access to isqlplus to only one user in my case. I need to give access in read only mode to user in isqlplus.For that, I will create a oracle user with only select privilege on the tables, but I want to be sure that only this user will be used in isqlplus and not another.
View 1 Replies View RelatedApplication Express :: Access Two Application With One Log In
Nov 19, 2012Apex 4.1.1
Oracle 11g
I have two applications both in the same workspace. I want to log into one of them, but then have a link to a page in the second application, without having to enter a login to the second application.
Trying to follow the following from a while back, but cannot make it work in apex 4.1.1. Is it possible to access two application with one login? Both application are using the same ldap authentication.
I have both applications using the same get cookie process on page 101
{
declare
v varchar2(255) := null;
c owa_cookie.cookie;
begin
c := owa_cookie.get('LOGIN_USERNAME_COOKIE');
:P101_USERNAME := c.vals(1);
exception when others then null;
end; }
The link I use to the second application is a javascript pop window for displaying the second application and call it with the java pop up url
{
javascript:popUp('f?p=366:1:&SESSION.:::::')
}
However, it still asks me for the login to the the second application. I found other conversations that said to fill in the cookie name in the Session Cookie Attributes in Security, Authentication of the second application and entered the cookie name LOGIN_USERNAME_COOKIE here. However I still get the second application login screen now with a bunch of numbers in the username field.
What am I missing to get this to work without having to login again for the second application?
Application Express :: Access For External File In Apex Page?
May 21, 2013How can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?
I created a page and button for link but struggling for above.
Application Express :: Access Oracle EBS Environment With Developer-level?
Jan 12, 2013how to integrate Application Express with Oracle EBS. Any companies that offer hosted EBS environment with APEX and allow developer-level access (ie database, application server, front-end responsibilities)?
View 1 Replies View RelatedHow To Disable SYSTEM Access From Client Users
Oct 29, 2012My requirement is to disable access of sys user from all clients even they are providing correct password.
View 2 Replies View RelatedApplication Express :: Create A Global Region In Page 0 And Then Access It From Other Pages?
Apr 26, 2013I have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.
To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.
Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.
My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)
PL/SQL :: Give ROLE Access To Users In Developer Tool?
Oct 5, 2013How to give ROLE access to users in PL/SQL developer Tool..??
View 3 Replies View RelatedApplication Express Listener :: Acquiring Access Token Via Coding - Not Web Logon Screen?
Sep 20, 2013I'm setting up APEX REST security by following the instructions from [URL]...Everything works great according to document.
I can acquire a token, then passing it in the header to get needed data from REST service. Consumer acquires an token by going on web browser to [URL]...
It will be redirected to[URL]... asking for username and password on browser. Once entering them correctly, it will be directed to Redirect URI defined in the OAuth2 client with the token in the URL.
My question is that is it possible to do token acquiring by coding (like in Salesforce) without going to web browser? We've tried doing that, it will stop due to redirect to sign-on.
Application Express :: Restarting APEX After Installation Configuration - Cannot Access Admin Screen?
Jul 20, 2012I installed and configures APEX in standalone mode about 2 weeks ago and played with it for short time. Now after 2 weeks I came back to start where I left off but APex_admin page would not come up.
I did following tasks as were found on Installed Apex on Oracle 11g. But cannot access admin screen
SQL> SELECT STATUS FROM DBA_REGISTRY
2 WHERE COMP_ID = 'APEX';
STATUS
-----------
VALID
SQL> conn sys as sysdba
Enter password:
[code]...
warning me that XDB requires username password to be sent through insecure manner (Basic authetication without a secure connection
Application Express :: How To Build Access Control Page Download Spreadsheet Data
Jul 2, 2013why the link provided under the How to Build an Access Control Page Download Spreadsheet Data Download the following *.csv file to your local system: In your Web browser go to:
[URL]............
returns nothing for me!
Find Sql Queries Run By Users Through Application?
Jul 10, 2012We have a database version 10.2.0.3 and it is connecting through an application with a schema called HR_OR.
I am using the below query to get sql statements.
SQL> SELECT
2 SST.VALUE CPU, S.USERNAME, S.SID, S.SERIAL#, SQL_TEXT
3 FROM
4 V$SESSION S,
5 V$SQLTEXT_WITH_NEWLINES T,
6 V$SESSTAT SST
7 WHERE S.SQL_ID IS NOT NULL
8 AND S.SQL_ID = T.SQL_ID
9 AND SST.SID = S.SID
10 AND SST.STATISTIC# = (SELECT STATISTIC# FROM V$STATNAME SN WHERE SN.NAME = 'CPU used by this session')
11 ORDER BY 1 DESC, S.SID,T.PIECE;
It is showing same query for all users and I tried to run the quey from sqlpus,getting error [SP2-0552: Bind variable "xxxx" not declared]. So I hv confusion here.
1. How I can see the queries running by users though application.
2. get the exact query run by users and the same query I want to run from sqlplus.
Audit Dml On Few Table For Non Application Users
Oct 12, 2013I want to audit dml on few table for non application users.can I omit only application users from audit so that whenever new user is created we need not to add audit for user.do i have to create audit logon trigger for this which check first the application user names from table and if logged user is not application user auditing will start for it.
View 4 Replies View Related
