tags:

views:

8

answers:

1
+1  Q: 

Drop user object in Oracle

Any one help me regarding orcal querry to drop user object?

A: 

The following statement drops the user, jones and all associated objects and foreign keys that depend on the tables owned by jones.

DROP USER jones CASCADE;

Oracle® Database Security Guide

Sudantha  2010-10-28 05:44:20

related questions

Using the results of a query in OPENQUERY
Search all tables in Oracle DB
Insufficient privileges when creating a trigger for a table in another schema
rebuild indexes oracle 10G
oracle 10G shrink datafiles
How do I limit the global memory resources of Oracle 10g database
Getting Hourly statistics using SQL
Problems importing SQL script from Oracle 9i to Oracle 10g express
Can someone explain oracle 10G encoding, nls_lang unicode
Is it possible to output a SELECT state from a PL/SQL block?
Null Pointer when populating Grails Domain object with Oracle 10g long field
Binding int64 (SQL_BIGINT) as query parameter causes error during execution in Oracle 10g ODBC
Why does Oracle require TO_NCHAR when binding SQL_C_WCHAR text via ODBC
ORACLE SQL: Need to sum two values, but one may not exist... Is this possible?
How do you programatically identify a stored procedure's dependencies?
How do I find out when a stored procedure was last modified or compiled?
ORACLE SQL: Multiple SUMS dependent on CODE in One Statement
How to read the PL/SQL code in an Oracle Forms .FMT file ?
How do I use oracle.jdbc.driver.OracleLog?
Table load via Partition Exchange (Oracle 10g)
"loader constraints violated when linking javax/xml/namespace/QName class" from webapp on Oracle 10g
JAXB 2 in an Oracle 10g Webapp
How do I change the IP address on Oracle 10g
How do I do a manual uninstall of Oracle?
Backup/Restore database for oracle 10g testing using sqlplus or rman