Collection Contents Index SYSUSEROPTIONS system view SYSVIEWS system view pdf/chap16.pdf

Reference Manual
   CHAPTER 16. System Views     

SYSUSERPERMS system view


CREATE VIEW SYS.SYSUSERPERMS
AS
SELECT user_id, user_name, resourceauth, dbaauth,
      scheduleauth, user_group, remarks
FROM SYS.SYSUSERPERM

Contains exactly the same information as the table SYSUSERPERM, except the password is omitted. All users have read access to this view, but only the DBA has access to the underlying table (SYSUSERPERM).


Collection Contents Index SYSUSEROPTIONS system view SYSVIEWS system view pdf/chap16.pdf