Viewing Password File Members (49)

tsinglee發表於2007-12-21

Use the V$PWFILE_USERS view to see the users who have been granted SYSDBA or
SYSOPER system privileges for a database. The columns displayed by this view are as
follows:
USERNAME : This column contains the name of the user that is recognized by the
password file.
SYSDBA : If the value of this column is TRUE, then the user can log on with
SYSDBA system privileges.
SYSOPER : If the value of this column is TRUE, then the user can log on with
SYSOPER system privileges.

檢視密碼檔案物件
透過檢視 V$PWFILE_USERS 可檢視賦予了sysdba與sysoper許可權的使用者

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-995392/,如需轉載,請註明出處,否則將追究法律責任。

相關文章