I need a query how to list all system privileges only (not the object ones) which are granted to each user in database. I need listed system privileges whatever they granted thru role or direct.

Thank you

1 Answer 1


"Retrieving all user privileges within Oracle can range from a simple task using a basic SQL query to an advanced script, depending primarily on how involved the roles and privileges are configured within the server."


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.