This content has been marked as final. Show 2 replies
user783239 wrote:You can create "Authorization Scheme" based on the roles defined in your table. You can then conditionally render the regions in your pages based on the Authorization Schemes.
Hi, 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:You can query the "apex_workspace_apex_users" and "wwv_flow_users" views for apex user details.