Skip to main content
Question

System Privilege Access

  • April 20, 2023
  • 3 replies
  • 110 views
T
Hero (Customer)
Forum|alt.badge.img+10

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

    H
    Hero (Employee)
    Forum|alt.badge.img+11
    • hhanse
    • Hero (Employee)
    • 200 replies
    • April 21, 2023

    SELECT * FROM DBA_SYS_PRIVS;
     

    K
    Superhero (Partner)
    Forum|alt.badge.img+17
    • knepiosko
    • Superhero (Partner)
    • 514 replies
    • April 21, 2023

    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)
    • 1265 replies
    • April 21, 2023

    Hi @TosohLBlum 

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

    You can show a list.

     

    Kind regards


    Terms & ConditionsCookie settingsAccessibility statement