Skip to main content
Skip table of contents

User and Role Management

The Data Virtuality Server has special stored procedures for Data Roles.

User Management

SYSADMIN.addUser

SQL
SYSADMIN.addUser(IN name string NOT NULL, IN pwd string NOT NULL, IN role_name string NOT NULL, OUT id biginteger NOT NULL RESULT

SYSADMIN.importUser

SQL
SYSADMIN.importUser(IN name string NOT NULL, IN encryptedPwd string NOT NULL, IN role_name string NOT NULL, IN loginAllowed boolean, OUT id biginteger NOT NULL RESULT)

Please keep in mind that this procedure:

  • Requires an encrypted password, not the real password;
  • Updates password and adds (if necessary) the indicated role for existing users;
  • Throws an exception if you are trying to import a "permanent" ("Admin") user.

SYSADMIN.renameUser

SQL
SYSADMIN.renameUser(IN name string NOT NULL, IN newName string NOT NULL)

SYSADMIN.deleteUser

SQL
SYSADMIN.deleteUser(IN name string NOT NULL)

SYSADMIN.changeUserPwd

SQL
SYSADMIN.changeUserPwd(IN name string NOT NULL, IN pwd, IN encryptedPwd)

SYSADMIN.getEncryptedUserPwd

SQL
SYSADMIN.getEncryptedUserPwd(IN name string NOT NULL, OUT encryptedPwd string NOT NULL RESULT)

SYSADMIN.getCurrentUser

This procedure returns the name of the current user.

SQL
SYSADMIN.getCurrentUser(OUT username string NOT NULL RESULT)

SYSADMIN.allowUserLogin

This procedure allows or disallows user login.

SQL
SYSADMIN.allowUserLogin(IN name string NOT NULL, IN loginAllowed boolean NOT NULL)

Role Management

SYSADMIN.addRole

SQL
SYSADMIN.addRole(IN name string NOT NULL, IN allowCreateTempTables boolean, OUT id biginteger NOT NULL RESULT)

SYSADMIN.renameRole

SQL
SYSADMIN.renameRole(IN name string NOT NULL, IN newName string NOT NULL)

SYSADMIN.deleteRole

SQL
SYSADMIN.deleteRole(IN name string NOT NULL)

SYSADMIN.addUserRole

SQL
SYSADMIN.addUserRole(IN user_name string NOT NULL, IN role_name string NOT NULL)

SYSADMIN.deleteUserRole

SQL
SYSADMIN.deleteUserRole(IN user_name string NOT NULL, IN role_name string NOT NULL)
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.