Skip Headers
Oracle® Database SQL Language Reference
11g Release 2 (11.2)

Part Number E26088-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
SQLRF01529

DROP PROFILE

Purpose

Use the DROP PROFILE statement to remove a profile from the database. You can drop any profile except the DEFAULT profile.

See Also:

CREATE PROFILE and ALTER PROFILE on creating and modifying a profile

Prerequisites

You must have the DROP PROFILE system privilege.

Syntax

SQLRF54919drop_profile::=

Description of drop_profile.gif follows
Description of the illustration drop_profile.gif

Semantics

SQLRF54920profile

Specify the name of the profile to be dropped.

SQLRF54921CASCADE

Specify CASCADE to deassign the profile from any users to whom it is assigned. Oracle Database automatically assigns the DEFAULT profile to such users. You must specify this clause to drop a profile that is currently assigned to users.

Example

SQLRF54922Dropping a Profile: Example The following statement drops the profile app_user, which was created in "Creating a Profile: Example". Oracle Database drops the profile app_user and assigns the DEFAULT profile to any users currently assigned the app_user profile:

DROP PROFILE app_user CASCADE; 
Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF