New in DA 6.1.5: Published Views tutorial

New in DA 6.1.5: Published Views tutorial

DA 6.1.5 includes published views to allow more advanced and flexible reporting on the deployments requests made:


  • Application process (view_app_proc_requests)
  • Component process (view_comp_proc_requests)


This guide takes you through installing and accessing the views using the three database technologies. It also contains fixes to the existing DDL scripts that were released with 6.1.5

The attached document covers the following:


Step 1: Install the published views 
Step 2: View the published views 
Step 3: Run a sample query 
Further Task 
Further Information



Download the attached document for more information.

Continue reading
1612 Hits

How-To: Find all users that have a privilege

In SBM, it is sometimes necessary to find out all users that have a specific privilege. This can be done easily by directly querying the database.  I referenced the SBM Schema guide for this information.

Privileges are stored in the TS_PRIVILEGES table.  A user will have multiple records depending privilege type.  To see what all the privilege types mean, please reference the SBM Schema guide.  Use the steps below to determine how to identify users that have a given privilege.

Recent Comments
George Jones
This is really cool - the simplicity is almost elegant. Love it! Thanks, David!
Friday, 22 April 2016 1:01 PM
Lynn Mattie
It should be noted that this will only find privileges directly granted to that user and does not include any privileges they migh... Read More
Friday, 22 April 2016 1:01 PM
cs joshi
Monday, 17 July 2017 5:05 AM
Continue reading
4304 Hits

Recent Tweets