# 22. Virtuoso Functions Guide - USER_DROP

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
db.dba.vacuum
user_change_password
user_create
user_drop
user_get_option
user_grant_role
user_revoke_role
user_role_create
user_role_drop
user_set_option
user_set_qualifier
cfg_item_count
cfg_item_name
cfg_item_value
cfg_section_count
cfg_section_name
cfg_write
checkpoint_interval
disconnect_user
fk_check_input_value...
log_enable
log_text
prof_enable
prof_sample
status
sys_lockdown
sys_stat
system
trace_status
user_set_password
virtuoso_ini_path
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## USER_DROP

This deletes a user ccount, optionally including schema objects, DAV resources and other possible resources owned by the user.
USER_DROP (in name varchar, in cascade integer);
Description

This is used to remove an existing user account from local security schema.

Parameters
name – A string containing the name of the user account to be deleted.
cascade – This flag (0/1) specifies whether to delete the stored procedures/functions, PL modules, tables and user defined types owned by the user. It cannot drop assembly definitions (created with CREATE ASSEMBLY), because CREATE ASSEMBLY is a database wide operation (done by the DBA group) so the assembly has no owner (since you can not drop DBA). The default value is zero. Sometimes it is not possible to drop the resources, for example if a table owned by the user is referenced by foreign key in a table that would not be dropped. The drop user will detect that and will print the appropriate error message (giving up the operation).
Return Types

None

See Also

User Options Section

USER_CREATE

USER_ROLE_CREATE

USER_ROLE_DROP

USER_CHANGE_PASSWORD

USER_SET_QUALIFIER

USER_GRANT_ROLE

USER_REVOKE_ROLE

USER_SET_OPTIONS

USER_GET_OPTIONS

DROP USER [CASCADE] statement