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

SETDEFAULT ROLE Command (database users)........................................................................119
Syntax.......................................................................................................................................119
Parameters................................................................................................................................120
Error Conditions.......................................................................................................................120
Example....................................................................................................................................120
User Management Views....................................................................................................................120
User Information for Database Users (HP_SECURITY.USERINFO)............................................120
Column Definitions..................................................................................................................120
Example Queries.................................................................................................................121
Roles for Database Users (HP_SECURITY.ROLEINFO)...............................................................121
Column Definitions..................................................................................................................122
Example Queries.................................................................................................................122
Database Users and Their Roles (HP_SECURITY.USERROLEINFO)...........................................123
Column Definitions..................................................................................................................123
Example Queries.................................................................................................................123
User Configuration Change Log for Database Users (HP_SECURITY.USERROLELOG)............124
Column Definitions..................................................................................................................124
Example Queries.................................................................................................................125
User Information for Platform Users (HP_SECURITY.SYSUSERINFO).......................................126
Column Definitions..................................................................................................................126
Example Query...................................................................................................................127
User Configuration Change Log for Platform Users (HP_SECURITY.SYSUSERLOG)................127
Column Definitions..................................................................................................................127
Example Queries.................................................................................................................128
User Access Log for Database and Platform Users (HP_SECURITY.USERACCESSLOG)...........128
Column Definitions..................................................................................................................128
Example Queries.................................................................................................................129
6 Database Security.....................................................................................................131
Database Views...................................................................................................................................131
Grant/Revoke Access to Database Objects .........................................................................................131
Displaying Privileges for a Database Object.......................................................................................132
Database Privileges for Neoview Roles and Special Users.................................................................132
Database Security Views.....................................................................................................................134
Database Users Registered on Neoview (HP_SECURITY.NEOUSERS).......................................134
Column Definitions..................................................................................................................134
Example Queries.................................................................................................................134
Roles Defined on Neoview (HP_SECURITY.NEOROLES)...........................................................135
Column Definitions..................................................................................................................135
Example Queries.................................................................................................................135
Schemas and Their Owners (HP_SECURITY.SCHEMALIST)......................................................136
Column Definitions..................................................................................................................136
Example Queries......................................................................................................................136
Privileges on Schemas in the NEO Catalog (HP_SECURITY.NEOSCHEMAPRIV).....................137
Column Definitions..................................................................................................................137
Example Queries......................................................................................................................137
Database Object Ownership (HP_SECURITY.NEOOBJECTLIST)................................................138
Column Definitions..................................................................................................................138
Example Queries......................................................................................................................139
Database Object Privileges (HP_SECURITY.NEOOBJECTPRIV).................................................140
Column Definitions..................................................................................................................140
Example Queries......................................................................................................................141
Database Column Privileges (HP_SECURITY.NEOCOLUMNPRIV)...........................................142
Column Definitions..................................................................................................................142
Table of Contents 7