 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
SQL Statements
The following SQL Statements were provided by users for the implementation of Best Practices.
All SQL statements should follow good standards before running them in your environment
including code review and proper testing in a test environment.
User functions: This SQL*Plus script will list all functions associated with a given user.
Amended to take into account any function or menu based exclusions - provided by Red Five,
appsuser11i@yahoo.co.uk; Applicability: 10.7, 11.0, 11i
User usage: SQL*Plus script to list users by that have not been used for a specified number of
days . Useful when performing a system cleanup in preparation for the implementation of a
SOD solution. Script will also list users that have never been used. - provided by Red Five,
appsuser11i@yahoo.co.uk; Applicability: 10.7, 11.0. 11i
All SQL statements should follow good standards before running them in your environment
including code review and proper testing in a test environment.
User functions: This SQL*Plus script will list all functions associated with a given user.
Amended to take into account any function or menu based exclusions - provided by Red Five,
appsuser11i@yahoo.co.uk; Applicability: 10.7, 11.0, 11i
User usage: SQL*Plus script to list users by that have not been used for a specified number of
days . Useful when performing a system cleanup in preparation for the implementation of a
SOD solution. Script will also list users that have never been used. - provided by Red Five,
appsuser11i@yahoo.co.uk; Applicability: 10.7, 11.0. 11i