Neoview Command Interface (NCI) Guide (R2.5)

ALTER USER Command
The ALTER USER command changes the NDCS privileges of a Neoview role.
Syntax
ALTER USER role-name, PERMISSION type
type is:
USER | OPERATOR
role-name
is the name of a Neoview role, such as ROLE.MGR.
PERMISSION USER
assigns USER privileges to the role. Users associated with roles that have USER privileges
do not have NDCS privileges and cannot change the status or configuration of the NDCS
services, data sources, or servers.
PERMISSION OPERATOR
assigns OPERATOR privileges to the role. Users associated with roles that have OPERATOR
privileges can configure and manage NDCS services, data sources, and servers.
Considerations
• To run this command in SQL mode, you must first run the CMDOPEN command. This
command does not run in CS mode.
• The command requires an SQL terminator.
• You must have OPERATOR privileges to display and change the NDCS privileges. Initially,
only members of SUPER.SUPER, SUPER.SERVICES, ROLE.DBA, and ROLE.SECMGR have
OPERATOR privileges.
• If you omit the PERMISSION clause in the command, the role acquires OPERATOR privileges.
Example
This command assigns USER privileges to ROLE.DBA:
SQL>alter user ROLE.DBA, permission user;
CMDOPEN Command
The CMDOPEN command enables you to run connectivity commands in SQL mode.
Syntax
CMDOPEN
Considerations
• This command runs in SQL mode only.
• The command requires an SQL terminator.
• Users associated with roles that have USER and OPERATOR privileges can execute this
command. For more information, see the “ADD USER Command” (page 158) or “ALTER
USER Command” (page 167).
ALTER USER Command 167