mxdbs db-user-change-access

Syntax

mxdbs db-user-change-access [-h | --help] database_name external_username { read | write | create | none }

Description

The mxdbs db-user-change-access sub-command modifies the access level of the specified database user.

Parameters

database_name
Specifies the name of the database.
external_username
Specifies the External Username of the database user whose access level must be altered.
read | write | create | none
Specifies the access level of the user on the schemas in the database.
  • READ access level grants the user SELECT, USAGE, and EXECUTE access on existing and future schemas in the database.
  • CREATE access level grants the user ALL access on existing and future schemas in the database, and CREATE SCHEMA access privilege on the database catalog.

  • WRITE access level grants the user ALL_DML access on existing and future schemas in the database.

  • NONE access level does not grant the user any access on existing and future schemas in the database. However, owners of objects in the database can explicitly grant access privileges to the user using the GRANT statement.

Options

-h | --help
Displays the help message and exits.

Considerations

  • A user is deleted from the existing access level privilege group and then added to the implicit privilege group for the specified access level. Performing this action alters access privileges of user on schemas in the database.

  • If a user is the last one with CREATE access level in the database, the access level cannot be changed to READ, WRITE, or NONE.

  • If a user owns any schema in the database, user access level cannot be downgraded from CREATE.
  • If the access level is downgraded from CREATE to READ, WRITE, or NONE, the CREATE SCHEMA access privilege is revoked for the user.

Example input and output

The following command changes the access level to CREATE.

mxdbs db-user-change-access db1 demouser1 create
Hewlett Packard Enterprise NonStop(TM) SQL/MX DBS Client 3.5
(c) Copyright 2016 Hewlett Packard Enterprise Development LP.

db-user-change-access command started.

---  mxdbs operation complete.