Oracle Tricks and Techniques in Supporting Systems Administration

Introduction

PPT Slide

Overview

SIMON

Simple Relations

/etc/passwd

Database Tables

LOGINS Table

SQL

Generate /etc/passwd

Logins Extended

LOGINS Table

/etc/group

Group Problems

GROUP Table

GROUP_MEMBERS Table

Group Relations

Generate /etc/group

oops…..

Access Control

Access Control

Oracle Authentication

Views

Simple View

User View

Complex View

Data Propagation

Data Propagation: Numeric

Sequences

Using Sequences

Find GROUP “version”

Get “NEW” logins

Data Propagation: Date

Between Databases

Data Propagation: Flag

Using Flags

Brute Force Compare

Rollback

Stored Procedures and Packages

PL/SQL

Add_Group_User

Packages

Demo.GetPwEnt

Database Triggers

Record Login.Source Changes

Oracle Signals and Pipes

Queue_PW_Change

Process_PW_Queue

Queue_Student_Pw_Change

Web Interface

OAS 3 Packages + Custom Interface

SISWeb Package

Web Support Packages

Voice_Mailbox

Voice Mailbox

Forward

PPT Slide

PPT Slide

Forward Window

Oracle Tricks and Techniques in Supporting Systems Administration