Neoview User Management and Security Administration Guide (R2.5)

Revoking a Role from a User....................................................................................................101
Changing a User's Default Role (or Your Own Default Role)..................................................102
Listing a User's Roles ...............................................................................................................102
Listing Your Own Roles ...........................................................................................................102
Changing a Database User Password.......................................................................................103
Changing Your Own Password................................................................................................103
Managing Platform Users..............................................................................................................104
Creating a Platform User Account...........................................................................................104
Deleting a Platform User Account...........................................................................................105
Changing a Platform User Password.......................................................................................106
Changing a Platform Role Password........................................................................................106
Changing Your Own Password................................................................................................107
User Management Commands...........................................................................................................108
ALTER PASSWORD Command (platform users, locally authenticated database users).............108
Syntax.......................................................................................................................................108
Parameters................................................................................................................................109
Examples..................................................................................................................................109
ALTER ROLE Command (platform roles, database roles)............................................................110
Syntax.......................................................................................................................................110
Parameters................................................................................................................................110
Example....................................................................................................................................111
ALTER USER Command (platform users, locally authenticated database users)........................111
Syntax.......................................................................................................................................112
Parameters................................................................................................................................112
Examples..................................................................................................................................113
CREATE ROLE Command (database roles)..................................................................................113
Syntax.......................................................................................................................................113
Parameters................................................................................................................................113
Error Conditions.......................................................................................................................113
Example....................................................................................................................................113
CREATE USER Command (platform users, database users)........................................................114
Syntax.......................................................................................................................................114
Parameters................................................................................................................................114
Error Conditions.......................................................................................................................116
Examples..................................................................................................................................116
DROP ROLE Command (database roles)......................................................................................117
Syntax.......................................................................................................................................117
Parameters................................................................................................................................117
Error Conditions.......................................................................................................................117
Example....................................................................................................................................117
DROP USER Command (platform users, database users)............................................................117
Syntax.......................................................................................................................................118
Parameters................................................................................................................................118
Error Conditions.......................................................................................................................118
Examples..................................................................................................................................118
GRANT ROLE Command (database users)..................................................................................118
Syntax.......................................................................................................................................118
Parameters................................................................................................................................118
Error Conditions.......................................................................................................................118
Example....................................................................................................................................119
REVOKE ROLE Command (database users).................................................................................119
Syntax.......................................................................................................................................119
Parameters................................................................................................................................119
Error Conditions.......................................................................................................................119
Example....................................................................................................................................119
6 Table of Contents