add_="schema"

<do action_="sql" add_="schema" objname_="[SCHEMA]" desc_="[DESCRIPTION]" users_="[USERS]" admins_="[ADMINS]"/> creates a new empty schema with the name [SCHEMA].

Description

add_="schema" signals an error unless the caller has the add_schema SQL privilege, with one exception: with the weaker add_self_schema privilege, a user named foo may call the transaction with objname_="self_foo". This is to facilitate creation of personal schemas by authorized users.

Syntax

<dynamic>
    <do action_="sql" add_="schema"
     objname_="[SCHEMA]"
     desc_="[DESCRIPTION]"
     users_="[USERS]"
     admins_="[ADMINS]"/>
</dynamic>

Attributes for add_="schema"

objname_
The name of the new schema. add_schema returns an error if the schema name already exists.
desc_
An optional string providing a description of the schema. The default value is the schema name.
users_
(Optional) A list of user and/or group names or a string containing a comma-separated list of user and/or group names. The default value is the caller's user ID.
admins_
(Optional) A list of user and/or group names or a string containing a comma-separated list of user and/or group names. The default value is the caller's user ID.