Manage Privileges - Silly Question — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Manage Privileges - Silly Question

Received Response
2
Views
6
Comments
User_9GFDT
User_9GFDT Rank 3 - Community Apprentice

Quick specific question that I'm having a hard time finding an answer on searching around.

What is the difference, in the Manage Privileges screen between Denied and just not leaving the value blank for a role?

I've tested this scenario and both the Denied value and no value give the same behavior. For example for Subject Area A, Denied and no value will make the subject area not appear for a specific user with the role.

Can anyone just break it down for me a bit more? What circumstance would I use Denied instead of the default no value? The only answer I found is that with users with multiple roles, setting to Denied will lock them out regardless of other privs/roles.

Thanks All.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    D Managing Security for Dashboards and Analyses

    D.2.3.1 What Are Presentation Services Privileges?

    Presentation Services privileges control the rights that users have to access the features and functionality of Presentation Services. Privileges are granted or denied to specific application roles, individual users, and Catalog groups using a privilege assignment table.

    Like permissions, privileges are either explicitly set or are inherited through role or group membership. Explicitly denying a privilege takes precedence over any granted, inherited privilege. For example, if a user is explicitly denied access to the privilege to edit column formulas, but is a member of an application role that has inherited the privilege, then the user cannot edit column formulas.

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    What Thomas Dodds said!

    In very simple terms, I think you could look at it like this...

    John is a member of the Sales group.

    You have given the Sales group permission to see the 'Commissions' subject area, but for whatever reason you don't want John to be able to see this subject area -- you DO however want all of the other members of the Sales group to see this subject area.

    So...you grant permission for the Sales group to see the 'Commissions' subject area, but then Deny John.

    Now everyone EXCEPT for John in the Sales group will be able to see the subject area.

    I realize the scenario I described isn't very realistic in terms of business, but you get my point.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    "Denied" wins. So when you grant and deny both (because you're part of 2 roles for exmaples) then you will be denied that functionality.

  • User_9GFDT
    User_9GFDT Rank 3 - Community Apprentice

    OK, that makes sense, so Denied wins everytime, and can specifically override inherited privs.

    But I guess the thing to note is that in MOST CASES I don't need to specifically deny permission to a privilege (if the user or access role is not Granted they wont see it or have the functionality by default).

    Is that statement correct?

    Thanks to all who replied, not sure who to mark as correct as they all seem correct.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    Eternalgradstudent2015-Oracle wrote:But I guess the thing to note is that in MOST CASES I don't need to specifically deny permission to a privilege (if the user or access role is not Granted they wont see it or have the functionality by default).

    No I tend to not use "Denied" at all if I can prevent it. Makes life a lot easier because you can work a lot better with application role inheritance.

  • User_9GFDT
    User_9GFDT Rank 3 - Community Apprentice

    Thank you again. Appreciate it.