User and Role Management
You are looking at an older version of the documentation. The latest version is found here.
The Data Virtuality Server has special stored procedures for user and role management.
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, 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.allowUserLogin
Allows or disallows user login.
SQL
SYSADMIN.allowUserLogin(IN name string NOT NULL, IN loginAllowed boolean NOT NULL)
SYSADMIN.allowUserLogin procedure is available since v3.14
encryptedPwd property in SYSADMIN.changeUserPwd available since v3.14
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)