| |
 |
|
Oracle Tips by Burleson |
Monitoring User Profiles
In addition to roles, each user is also assigned profiles. Each user
gets the default profile if he or she is not explicitly assigned to
a different profile. Profiles control resource usage and, with
Oracle8, Oracle8i, and Oracle9i, password security. Source 11.5 is a
script that shows the different user profiles. The output of Source
11.5 is shown in Listing 11.4.
SOURCE 11.5 Script to generate a report on Oracle8, Oracle8i, and
Oracle9i user resource profiles.
REM NAME : PROFILE_REPORT.SQL
REM PURPOSE : GENERATE USER PROFILES REPORT
REM Revisions:
REM Date Modified by Reason for change
REM 08-Apr-1993 MIKE AULT INITIAL CREATE
REM 14-May-1999 MIKE AULT Added resource_type
REM
SET FLUSH OFF TERM OFF PAGESIZE 58 LINESIZE 78 VERIFY OFF FEEDBACK
OFF
COLUMN profile FORMAT a15 HEADING Profile
COLUMN resource_name FORMAT A25 HEADING 'Resource:'
COLUMN resource_type FORMAT A9 HEADING 'Resource|Affects'
COLUMN limit FORMAT a20 HEADING Limit
START title80 'ORACLE PROFILES REPORT'
BREAK ON profile
SPOOL rep_out/&&db/prof_rep
SELECT
profile,resource_name,
resource_type,limit
FROM
sys.dba_profiles
See code depot
This is an excerpt by Mike Ault’s book “Oracle9i
Administration & Management” . If you want more current Oracle
tips by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s
Oracle Scripts Download. |
