1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Security on Application and Report level

Discussion in 'Oracle Application Express (APEX)' started by Bharat, Nov 4, 2014.

  1. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi All,

    How can we provide security on Applications and reports to provide access to the users ?

    1. On one Application we have 2 tabs and each tab contains 10 reports. Now for 1 user we need to provide access to 5 reports each tab and another user we need to provide all reports to access.
    2. We have 3 applications with 5 to 10 reports each application. Now how can we provide access to each application with 1 user ? Like whenever we give permissions to the user to access the Application then only he can access to that Application.
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Anyone please guide us on security levels on Applications and Pages in Oracle APEX.
     
  3. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    I have found the easiest way is to use Groups. But it can be labor intensive if the community has a lot of turnover. Another solution is to have an access table and reference that in your restrictions.

    HTH

    CJ
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi CJ,

    How can we achieve using Groups ?
     
  5. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    When creating a user you have the option of assigning that user to a Group Name. That same Admin screen allows you to create the Groups...you can have as many as you want. Then, in the regions / items / tabs / whatever you can create restrictions based on the logged user's Group membership. There are several APIs available in APEX_UTIL referencing the groups.

    HTH

    CJ
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    So can we assign single user to multiple groups ?
     
  7. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Yes....and you can assign multiple groups to a single user.
     
    Bharat likes this.
  8. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Can you please provide me some examples or documents on creating groups.
     
  9. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Just open the Admin page where you create the user...there's a tab for groups. ;-)
     
  10. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    users creation page means to create Developers User account or Application Running environment?
     
  11. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    It means you need to create an APEX user account...whether or not the account is a developer, Admin, or not is entirely up to you. But the account must exist in order to assign a group to the account.