theonlyalterego

Member since 08/11/2008

8 snippets

2749 profile views

1 Comment(s) Posted

View their favorites

their Tags

Oracle java Bash linux database sql list windows class forms search find unix security

Profile

Achievement

first submission:submitting first snipplet

theonlyalterego's Recent SnippetsTagged sql

All /

« Prev 1 Next »

SQL Oracle Find Profile Values for User

find what profile values are set for a particular user

sql

0 635 posted 11 years ago by theonlyalterego

SQL Query to find Parameters and Value Sets associated with a Concurrent Program

This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name

sql

0 949 posted 12 years ago by theonlyalterego

SQL Oracle SQL - get a list of most recent user logins

Query to find the most recent logins for a particular user ( find 1 years worth )

sql

0 816 posted 12 years ago by theonlyalterego

SQL Oracle - Find which users have FND Diagnostic profile value set

A slight adaptation on the sql in the Oracle Forum

sql

0 867 posted 12 years ago by theonlyalterego

SQL Oracle - Find all responsibilities and concurrent program names based on the executable Name

sql

0 819 posted 12 years ago by theonlyalterego

SQL Oracle - sql to find what responsibility can run a request / report

Very useful sql to find which responsibility has access to a report or request.

sql

0 1864 posted 12 years ago by theonlyalterego

PL/SQL Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

sql

0 1152 posted 12 years ago by theonlyalterego

SQL Oracle SQL - Select OAF File version history

This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file....

sql

0 675 posted 15 years ago by theonlyalterego

« Prev 1 Next »