How can I get a list of all my RBS (row-based security) procedures?

Available Languages

Download Options

  • PDF     (3.4 KB)
    View with Adobe Reader on a variety of devices
  • ePub     (66.9 KB)
    View in various apps on iPhone, iPad, Android, Sony Reader, or Windows Phone
  • Mobi (Kindle)     (66.9 KB)
    View on Kindle device or Kindle app on multiple devices
Updated:March 21, 2017
Document ID:201411

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Introduction

This documents describes how to get the list of all Row-Based Security (RBS) Procedures as when you create a free form row-based security policy, a Composite procedure is created. It serves to customize the behavior of the SQL statement.

How to get the list of all RBS procedures?

Run this query in Scratchpad:

select * from /services/databases/system/ALL_RESOURCES where ANNOTATION like 'Row Level%'

TAC Authored

Contributed by Cisco Engineers

  • Anil Prabhu
    Cisco TAC Engineer

Was this Document Helpful?

FeedbackFeedback

Contact Cisco