Styjun

As an Operations Research professional, how is your time divided when working on an optimization project?

Do equal angles necessarily mean a polygon is regular?

What is this opening trap called, and how should I play afterwards? How can I refute the gambit, and play if I accept it?

Why isn’t the tax system continuous rather than bracketed?

"Strength" of free falling objects' ground-impact

Alphabet completion rate

Ending: accusative or not?

In the Marvel universe, can a human have a baby with any non-human?

Are Finite Automata Turing Complete?

How to determine what is the correct level of detail when modelling?

How to reply to small talk/random facts in a non-offensive way?

Analog is Obtuse!

Should I hide continue button until tasks are completed?

What would Earth look like at night in medieval times?

Is it OK to bottle condition using previously contaminated bottles?

Should I include salary information on my CV?

What is the line crossing the Pacific Ocean that is shown on maps?

Fedora boot screen shows both Fedora logo and Lenovo logo. Why and How?

Do French speakers not use the subjunctive informally?

Can I cast reaction spells like Shield or Counterspell when I'm in the middle of casting a spell with a long casting time and don't stop casting it?

Does Marvel have an equivalent of the Green Lantern?

Does ultrasonic bath cleaning damage laboratory volumetric glassware calibration?

How risky is real estate?

What reason would an alien civilization have for building a Dyson Sphere (or Swarm) if cheap Nuclear fusion is available?

How to implement APP_USER variable in oracle apex

How does database indexing work?How can I prevent SQL injection in PHP?Get list of all tables in Oracle?How do I limit the number of rows returned by an Oracle query after ordering?How do I UPDATE from a SELECT in SQL Server?Dynamic action using date picker in APEX 5.0Referencing oracle apex APP_USERClose modal dialog page and refresh the page Oracle APEXOracle Apex - Download CSV produces an empty reportLinking user accounts to primary key values in Oracle Apex

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have a teacher table that stores a teacher username, password, id and other things. I have a course creation page and a teacher details page. Currently, when a teacher logs in with their username and password and clicks on the teacher details page, they can see every other teachers details including their own and can edit every teachers details. I want to allow the teacher to only edit and see their details. I know this will involve using the app_user variable but i have no idea how to implement this (would it be a dynamic action or computation). I also dont know what sql expression i would write. If someone could list the steps to do this and the type of code i would need to write that would be appreciated.

Thanks.

sql oracle oracle-apex oracle-apex-5

share|improve this question

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

add a comment | 

1

I have a teacher table that stores a teacher username, password, id and other things. I have a course creation page and a teacher details page. Currently, when a teacher logs in with their username and password and clicks on the teacher details page, they can see every other teachers details including their own and can edit every teachers details. I want to allow the teacher to only edit and see their details. I know this will involve using the app_user variable but i have no idea how to implement this (would it be a dynamic action or computation). I also dont know what sql expression i would write. If someone could list the steps to do this and the type of code i would need to write that would be appreciated.

Thanks.

sql oracle oracle-apex oracle-apex-5

share|improve this question

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

add a comment | 

I have a teacher table that stores a teacher username, password, id and other things. I have a course creation page and a teacher details page. Currently, when a teacher logs in with their username and password and clicks on the teacher details page, they can see every other teachers details including their own and can edit every teachers details. I want to allow the teacher to only edit and see their details. I know this will involve using the app_user variable but i have no idea how to implement this (would it be a dynamic action or computation). I also dont know what sql expression i would write. If someone could list the steps to do this and the type of code i would need to write that would be appreciated.

Thanks.

sql oracle oracle-apex oracle-apex-5

share|improve this question

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

share|improve this question

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

share|improve this question

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

edited Mar 25 at 16:23

chrisis

1,44055 gold badges1515 silver badges1616 bronze badges

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

asked Mar 25 at 11:02

john leonardjohn leonard

2111 bronze badge

2 Answers
2

active

oldest

votes

3

You can use :APP_USER as shown below

SELECT * FROM some_table WHERE user_id = :APP_USER

Below link helps you to learn more about it.

https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

add a comment | 

0

you have to use this query in your teacher details region

select * from teacher_details where user_name = :APP_USER;

for more details https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55336340%2fhow-to-implement-app-user-variable-in-oracle-apex%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

You can use :APP_USER as shown below

SELECT * FROM some_table WHERE user_id = :APP_USER

Below link helps you to learn more about it.

https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

add a comment | 

3

You can use :APP_USER as shown below

SELECT * FROM some_table WHERE user_id = :APP_USER

Below link helps you to learn more about it.

https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

add a comment | 

You can use :APP_USER as shown below

SELECT * FROM some_table WHERE user_id = :APP_USER

Below link helps you to learn more about it.

https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

SELECT * FROM some_table WHERE user_id = :APP_USER

share|improve this answer

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

answered Mar 25 at 12:15

AhamedAhamed

27711 silver badge88 bronze badges

0

you have to use this query in your teacher details region

select * from teacher_details where user_name = :APP_USER;

for more details https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges

add a comment | 

0

you have to use this query in your teacher details region

select * from teacher_details where user_name = :APP_USER;

for more details https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges

add a comment | 

you have to use this query in your teacher details region

select * from teacher_details where user_name = :APP_USER;

for more details https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#BEIHCJBG

share|improve this answer

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges

select * from teacher_details where user_name = :APP_USER;

share|improve this answer

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges

answered yesterday

mohamed subhi bouchimohamed subhi bouchi

133 bronze badges