万能百科  > 所属分类  > 

Examinethecode:CREATEROLEreadonlyIDENTIFIESUSINGapp.chk_readwrite;CREATEROLEread

Examinethecode:CREATEROLEreadonlyIDENTIFIESUSINGapp.chk_readwrite;CREATEROLEreadwriteIDENTIFIEDUSINGapp.chk_readwrite;CREATEORREPLACEPROCEDUREapp.chk_readwriteAUTHIDCURRENT_USERISipchkSTRING(30);BEGINIFsys_context(‘USERENV’,’ISDBA’)=’TRUE’THENDBMS_SESSION.SET_ROLE‘READWRITE’);ELSEDBMS_SESSION.SET_ROLE(‘READONLY’);END;/WhichthreestatementscorrectlydescribetheSecureApplicationroledefinition?()

A.Nouserorapplicationhastorememberorhideapassword.

B.ItpreventseveryoneexceptatrueDBAsessionfromacquiringtheREADWRITErole.

C.app.chk_readwriteiscalledwheneverausertriestoaccessrowsprotectedbytheREADONLYorREADWRITElabel.

D.app.chk_readwriteiscalledbyusersorapplicationswhentheywanttoenabletheREADONLYor READWRITErole.

正确答案:

参考A, B, D

词条内容仅供参考,如果您需要解决具体问题
(尤其在法律、医学等领域),建议您咨询相关领域专业人士。

标签