Chapter 16 System Views
1075
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).
To Next Page
Loading...