create_user

Creates a new database user. The name of the new user must differ from all existing database users.

Note that the new user will have logins disabled and will not have a password set. You can use the alter_user function to enable logins and set a login password.

Available in the star$administration database and requires the star$administration role.

Parameters:

Name Optional Type Description
user$ Mandatory Text  The name of the database user to be created.

Examples:

SELECT create_user('myuser'); -- creates a new user called 'myuser'.

Tips:

  • The star$users view indicates which users already exist.
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk