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.