SYSUSERAUTH system view
1072
SYSUSERAUTH system view
CREATE VIEW SYS.SYSUSERAUTH ( name, password,
resourceauth, dbaauth, scheduleauth, user_group )
AS
SELECT user_name, password, resourceauth,
dbaauth, scheduleauth, user_group
FROM SYS.SYSUSERPERM
Presents all the information in the table SYSUSERPERM except for user
numbers. Because this view shows passwords, this system view does not
have PUBLIC select permission. (All other system views have PUBLIC
select permission.)
To Next Page
Loading...