You need to provide bit more information as you want to control data by user, dept, organisation region etc. As apex by itself has no inbuilt functionality for data view restriction. Also you wanted to implement in new application or existing application. Please provide all the requirements.
14-Mar-2018 08:38:AM by: pkpanda
Hello @lsurana, you can create a customized table lets call it (user_groups) and configure the users and their categories within this table, then you check with the query to allow only specific user's groups to see the data or not. thats on data level, you can use Authentication scheme on Pages, regions level.
13-Mar-2018 11:36:AM by: qais_a.ibrahim
Hi, what will best practice to have data security in APEX. Am not saying Authorization. I want specific data only visible to specific user , admin will able to full data. Only SQL where clause is option ? or is any best option for data security ?
13-Mar-2018 11:00:AM by: lsurana
APEX 18.1 EA2 is now available @
12-Mar-2018 06:14:PM by: orcl_dpeake
@lsurana You need to look at using Kerberos authentication. @nielsdb Has written an article - documenting the steps required. It works, I am using it on multiple application in a production environment
12-Mar-2018 08:33:AM by: shaun.mauer
@qais_a.ibrahim How we get user name password default and redirect automatically to application. There will be no login screen. Please guide
12-Mar-2018 07:33:AM by: lsurana
@qais_a.ibrahim Hi Thanks. LDAP authentication is working fine for me. We looking no login screen option, default need to take from system user name password like Oracle Single sign on works. Looking solution for this.
12-Mar-2018 07:32:AM by: lsurana
@lsurana you can use the active directory and setup the passwords there, the APEX_LDAP package will handle the rest read more:
12-Mar-2018 07:28:AM by: qais_a.ibrahim
@maxime_tremblay many thanks for this interesting link
12-Mar-2018 07:27:AM by: thkl
please guide
12-Mar-2018 06:51:AM by: lsurana
Hi All, one more question related to SSO, we configured to LDAP which working fine. But user dont want to put user name password again, need to use windows system password directly
12-Mar-2018 06:51:AM by: lsurana
Hi All, i want to know Team Development feature in APEX. Can 2 or 3 developer work on same application simultaneously. ? please guide
12-Mar-2018 06:16:AM by: lsurana
Hey Everyone! I love to use the Interactive Grid. But when the users save private Reports I always get the error ORA-06502. Does someone know what I can do to fix this error?
11-Mar-2018 05:37:PM by: martin_wolz
and not able to create any objects its saying SYSTEM not having privilages
11-Mar-2018 12:35:PM by: lsurana
we migrated to 12c structure little getting confuse to me, am not able to find apex_mail package
11-Mar-2018 12:35:PM by: lsurana
Anybody having install APEX on 12c
11-Mar-2018 12:34:PM by: lsurana
11-Mar-2018 12:34:PM by: lsurana
11-Mar-2018 08:05:AM by: priyaarora.280
its working fine in
11-Mar-2018 08:01:AM by: qais_a.ibrahim
i didn't noticed that, which apex version do u use?
11-Mar-2018 08:01:AM by: qais_a.ibrahim
The column name in query used is "CPT_COST_PER_TEMPLATE" In the label it is 'Cost/Theme$' Apex is treating '/' it as a character and changing it's value from'/' to '&#x2F'
11-Mar-2018 07:55:AM by: priyaarora.280
Hello , i guess you need to change the column name in the query itself (the last column) , you can use column aliases in the IR
11-Mar-2018 07:52:AM by: qais_a.ibrahim
Does anyone here that has ever documented an APEX Application has a Word or Google Doc *template* to start with? I saw an old presentation from Dietmar about *auto-documentation*, but I think the solution is not available.
09-Mar-2018 06:07:PM by: sandrogfr
@thkl I did a blogpost about this not too long ago, might be of some help to you:
09-Mar-2018 05:45:PM by: maxime_tremblay
many thanks
09-Mar-2018 03:37:PM by: thkl
@thkl you need to change the Application Primary Language. For example, en-gb uses Monday as the first day of the week.
09-Mar-2018 03:34:PM by: craigsykes
Hello, I am looking for a way to change the data-picker so, that it shows the Monday in the first column instead of the sunday, Is there a way?
09-Mar-2018 02:54:PM by: thkl
Does anyone know why the colour #ED7000 doesn't save in theme roller? It seems to switch to #ED6F00 every time on a couple of environments. I can set the correct one using CSS, but not theme roller.
09-Mar-2018 11:21:AM by: craigsykes
Just a normal interactive report showing a list of the documents already uploaded
08-Mar-2018 03:41:PM by: jeanparadis
@jeanparadis do you have an interactive report on your page? or is that custom JS code on your page/app?
08-Mar-2018 03:33:PM by: maxime_tremblay
Thanks Maxime. I always forget about this. There is an error on a IR report about setTableHeadersAsFixed being undefined
08-Mar-2018 03:10:PM by: jeanparadis
@jeanparadis if you look at the console, do you see any javascript error?
08-Mar-2018 03:07:PM by: maxime_tremblay
I have an application (Application Express with a dozen pages or so. All of them display the Apex toolbar at the bottom except 2 of them. Those 2 pages have a "File Browse" item of them. Do you know what would prevent the toolbar from showing?
08-Mar-2018 02:59:PM by: jeanparadis
It returns the Interactive Report but not the Interactive Grid
07-Mar-2018 02:35:PM by: vjekoslav
Hello @vjekoslav. Have you tried the function APEX_IR.GET_REPORT ? The object returned contains the sql query
07-Mar-2018 11:04:AM by: benjamin_dng
Hello, how can I get the activ query of an interactive grid
06-Mar-2018 08:43:PM by: vjekoslav

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
17-Mar-2018 01:15
Unable to create new database link as Administrator.
1 replies - last reply: 17-Mar-2018 03:13- by: Alli Pierre Yotti
17-Mar-2018 00:51
Error 'Not exist' when trying to delete existing Oracle Text preference
1 replies - last reply: 17-Mar-2018 11:12- by: fac586
Ahmed AL-Saie
16-Mar-2018 23:40
Problem with charts when use database link
1 replies - last reply: 17-Mar-2018 03:22- by: Alli Pierre Yotti
16-Mar-2018 21:52
Is one login for different versions of APEX possible?
2 replies - last reply: 17-Mar-2018 08:25- by: fac586
16-Mar-2018 17:49
Reduce Space between Item Label and Text Field
3 replies - last reply: 16-Mar-2018 18:14- by: fac586
16-Mar-2018 17:11
How to set the value of an item using dynamic action
1 replies - last reply: 16-Mar-2018 17:24- by: Alli Pierre Yotti
16-Mar-2018 16:21
Creating a Collection from a query
5 replies - last reply: 16-Mar-2018 19:52- by: hmaguire
16-Mar-2018 14:54
re: Error during rendering of region "Resource Template".
3 replies - last reply: 16-Mar-2018 16:22- by: Alli Pierre Yotti
16-Mar-2018 14:42
Generating PDF output for dashboards
2 replies - last reply: 17-Mar-2018 13:56- by: Dimitri Gielis
16-Mar-2018 12:56
Problem: secure Apex REST services with OAuth2
0 replies
16-Mar-2018 12:40
How do I reload the page after time-out?
5 replies - last reply: 16-Mar-2018 20:43- by: Alli Pierre Yotti
16-Mar-2018 10:00
Column grouping in Interactive report
4 replies - last reply: 16-Mar-2018 12:54- by: Alli Pierre Yotti
Rajeev De Sil
16-Mar-2018 09:50
Multiple Dynamic Actions on Page Item
1 replies - last reply: 16-Mar-2018 23:17- by: LA County APEX
15-Mar-2018 22:03
change parsing schema at a runtime
6 replies - last reply: 16-Mar-2018 15:11- by: Christian Neumueller-Oracle
15-Mar-2018 19:14
Desktop Navigation Menu
3 replies - last reply: 16-Mar-2018 10:58- by: Alli Pierre Yotti
15-Mar-2018 17:33
Help text Bug. Where to report?
2 replies - last reply: 16-Mar-2018 16:25- by: Jabbamp
15-Mar-2018 15:26
Apex 5.1 How to display certain button in a checkbox
1 replies - last reply: 16-Mar-2018 23:31- by: LA County APEX
Bernhard FW
15-Mar-2018 11:47
TREE - 2nd leave/level ordering numbers - how ?
6 replies - last reply: 16-Mar-2018 11:16- by: fac586
Davor Maric
14-Mar-2018 08:48
Send mail using APEX_MAIL without APEX
3 replies - last reply: 16-Mar-2018 17:23- by: Davor Maric
13-Mar-2018 22:42
CSV Export Slow Speed
3 replies - last reply: 17-Mar-2018 07:56- by: ReWritten
Kevin Zhang
13-Mar-2018 20:05
How to trigger client-side validation for SkillBuilder Super LOV3 in APEX 5.1
4 replies - last reply: 16-Mar-2018 19:15- by: Kevin Zhang
13-Mar-2018 19:24
Dynamically change column values
2 replies - last reply: 16-Mar-2018 15:55- by: Rotan
12-Mar-2018 18:40
Custom Authorization schema-roles and access
7 replies - last reply: 17-Mar-2018 14:18- by: user6343299
09-Mar-2018 23:43
IG cascading LOV filter
2 replies - last reply: 17-Mar-2018 09:34- by: DejanH
Tony Andrews
09-Mar-2018 14:06
Getting unwanted new session after using apex_custom_auth.post_login
2 replies - last reply: 16-Mar-2018 16:09- by: Tony Andrews

CSS for Home-Pages 1,10,20