Oracle PL/SQL: Drop User example - Drop the account that owns the database objects required to run<br /> the applications discussed in

Quick Search:

Oracle PL/SQL: Drop User example

Jump to:

Category: >> Oracle PL/SQL >> Drop User example

<< last

next >>

Snippet Name: Drop User example

Description: Drop the account that owns the database objects required to run
the applications discussed in "Developing Oracle Forms Applications."

Also see:
» Create a drop down menu from an array ...
» Drag And Drop Example
» DHTML Combo Box Dropdown
» FUNCTIONS: drop
» TABLESPACE: Dropping Tablespaces
» INDEXES: DROP index
» USER: connection information
» USER: User Information 2
» USER idle time
» USER Information
» USER active connected users
» USER memory use
» USER: Connected Users
» USER: drop user
» USER: misc queries and commands
» USER system authentication
» USER lock account
» USER password expiration
» USER profile
» USER tablespace quota
» USER temp tablespace
» USER tablespace
» USER password
» USERS: view specific user info
» USERS: view currently connected users
» USERS: view all active users
» USERS: Drop users
» USERS: Lock and Unlock accounts
» USERS: Proxy Users
» USERS: Grant tablespace access

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

SET VERIFY OFF
ACCEPT sys_pass PROMPT 'Please enter password for user SYSTEM : ' hide
ACCEPT db_name PROMPT  'Enter database name or connection string.  Default is [LOCAL] : '
 
REM CONNECT
CONNECT SYSTEM/&sys_pass@&db_name
ACCEPT u_name       PROMPT  'Enter user name: '
 
DROP USER &u_name CASCADE;
 
EXIT;
 
WHENEVER SQLERROR EXIT