Skip to main content
Question

System Privilege Access

  • Apr 20, 2023 6:39 PM UTC
  • 3 replies
  • 137 views
Hero (Customer)
Forum|alt.badge.img+11

Is there a way to see what users are granted system privileges?  I know I can look at each individual permission set and see if any system privileges are assigned, but that is very time consuming.

    3 replies

    Hero (Employee)
    Forum|alt.badge.img+11
    • hhanse
    • Hero (Employee)
    • Apr 21, 2023 5:50 AM UTC

    SELECT * FROM DBA_SYS_PRIVS;
     

      Superhero (Partner)
      Forum|alt.badge.img+17
      • knepiosko
      • Superhero (Partner)
      • Apr 21, 2023 7:00 AM UTC

      If we are looking for IFS system privileges not Oracle system then following query is helpful:

      select * from SYSTEM_PRIVILEGE_GRANT_TAB

       

      Piotr --> https://www.linkedin.com/in/piotr-skowronek-8425aa6/
        Link
        Superhero (Customer)
        Forum|alt.badge.img+23
        • Link
        • Superhero (Customer)
        • Apr 21, 2023 7:50 AM UTC

        Hi @TosohLBlum 

        the easiest way to find it out is with rmt on system privileges.

        You can show a list.

         

        Kind regards
          Terms & ConditionsAccessibility statement