MichaelB.
7/28/2018 - 2:02 PM

CREATE/DROP a USER

You can create a user via SQL or via the Security folder in Systems -> right-click -> New User. The user will have less authorizations than the SYSTEM user, which is the Admin/Super user for the DB.

sql
content_copyfile_download
-- Create a user
CREATE USER 'user name' PASSWORD 'password';


-- Drop a user
DROP USER 'user name';