Help! Trying to create a tracker for the team - Limit User viewership

User_7A04P

Hey Team,

I was trying to create an application to track certain details but the data is viewable to everyone . I want to limit data view to only that individual and the entire data to the Administrator only.

Please help me out!

I have no experience in coding etc :)

Thanks,

Benson

InoL

I have no experience in coding etc :)

Authorization is very basic, but if you have no experience, what can you do?

You need to have some authorization in your query:

select ...
from ...
where user_that_created_the_record = :APP_USER
or <user_is_administrator>

<user_is_administrator> is up to you, as it depends on your application how that is defined.

User_7A04P

Thanks for the reply.

Please dumb it down to me since I have absolutely no prior experience in this.

I have a report with form and I want them to be able to view only their respective entries.

Attaching the table screenshot if that help.

A.PNG

InoL

Sorry, but it is difficult to give any further advice without knowing the details.

I want to limit data view to only that individual

Is there some column in the table to indicate which user created the entry? If not, it is not possible to limit the view to what you entered yourself.

the entire data to the Administrator only.

How do you know that a user is an administrator? We don't know that.

User_7A04P

Column 5 is the entry where you select your name .

InoL

https://community.oracle.com/tech/developers/discussion/comment/16772362#Comment_16772362

Bid manager? That is empty. So you cannot use that to select only your records. Or do you want something like

where bid_manager = :APP_USER or bid_manager is null

User_7A04P

Thanks so much for your help.

bid_manager = :APP_USER 

ended up not showing any data even though my name was mentioned in the column.

Is there something I'm missing?

A.PNG

InoL

https://community.oracle.com/tech/developers/discussion/comment/16772412#Comment_16772412

The names I see in that column are clearly not login userids. APP_USER is the login id.

User_7A04P

Sorry but APP_USER is the E-mail ID correct?

InoL

https://community.oracle.com/tech/developers/discussion/comment/16772443#Comment_16772443

I don't know what you mean by email ID. APP_USER is the application login username. Check the Apex manual:

https://docs.oracle.com/en/database/oracle/application-express/20.1/htmdb/understanding-substitution-strings.html#GUID-3AFC7346-902C-4DCA-8D28-960BD8FC6628

User_7A04P

okay after some reading a little I got a hang of it , I think.

How do I set BID_Manager as APP_USER automatically ?