CREATE_USER

Create a user.

Parameter Name	Required	DefaultValue	Parameter-Description
p_user_name	yes		user name
p_user_type	yes		HU (human user) GU (generic user) TU (technical user)
p_authentication			Password (default if null) LDAP: enter the string “@LDAP:” followed by the user DN (distinguished name) Kerberos principal: enter the string “@KRB:” followed by the KERBEROS ID
p_private_sbx		false	create a private sandbox
p_quota	yes		schema quota in GB (<0 means infinite)
p_comment			comment
p_email			mail address; if set a notification will be sent

Example

EXECUTE SCRIPT api_scurty.create_user
            ( 'XXX'    -- p_user_name
            , 'HU'     -- p_user_type
            , null     -- p_authentication
            , false    -- p_private_sbx
            , null     -- p_quota
            , 'XXX'    -- p_comment
            , 'XXX'    -- p_email
            );