Member Avatar for maverick420

Oracle query to display all policies existing in the database?

Can anyone tell me what will be the "Oracle Query to display all policies existing in the database"?

Edited by diafol because: not a code snippet
  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by shapam
Member Avatar for shapam

select * from all_policies; (gives all_database policies)
or
select * from DBA_POLICIES;(gives only dba users policies)
or
select * from user_policies;(gives only the particular user policies).

use any of the above query u'l get the policies which ever exitsts in database

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.