Home/ Questions/Q 245
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-08-20T18:51:38+00:00

Display roles hierarchically in LOV with Shuttle

  • 1
  • 1

Hi!

I use List Of Value with shuttle, to assign user roles.

I want to display roles hierarchically, for instance, when user who is logged in, has an Admin role this user should be able to see all roles and assignee them to selected user from LOV item. When user have Moderator role, then should be able to see users who are the moderators and all other who are below this role. And user should be unable to see roles above own role in shuttle.

Thanks in advance

oracle apexsql
Share
Leave an answer

Leave an answer

Browse

5 Answers

  1. Basically, you need the SQL query for LOV, and for this, I must know your table structures related to user and user roles master, etc.

    For now, I assume your tables and columns and writing an example query below:

    Select Roles from user_roles
    where user_type = (Select user_type from user_master
                       where user_id = :APP_USER);

    The above query is just an example, actually, you should assign the user type to an application item at the time of login.

    Let me know if I understood it right and if I am right then you have to describe your table structures so that I can give you a better example.

     

  2. This answer was edited.

    Thanks for response Vinish!

    For instance, I have roles: ADMIN, MODERATOR, EDITOR, READ_ONLY

    Admin should be able to change roles for all users and can see all roles in shuttle and assign them to users.

    Moderator should be able to see MODERATOR, EDITOR and READ ONLY users. And can assign all roles except ADMIN(this role should not be shown in the shuttle).

    Here is example of my tables:

    Users (
    ID number
    , USERNAME varchar2(32)
    , PASSWORD varhcar2(32)
    )

    I have link tables for Roles and Privileges :

    User_roles (
    FK_USER_ID number
    , FK_ROLE_ID number
    )

    User_privs (
    FK_ROLE_ID NUMBER,
    FK_PRIV_ID NUMBER
    )

    Roles (
    ID number
    , NAME varchar2(32)
    , DESCRIPTION varchar2(64)
    )

    Privileges (
    ID number
    , PRIV_NAME varchar2(32)
    , DESCRIPTION varchar2(64)
    )