试题详情
- 多项选择题 Examine the code: CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ; CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ; CREATE OR REPLACE PROCEDURE app.chk_readwrite AUTHID CURRENT_USER IS ipchk STRING(30); BEGIN IF sys_context(‘USERENV’,’ISDBA’)=’TRUE’ THEN DBMS_SESSION.SET_ROLE‘READWRITE’) ; ELSE DBMS_SESSION.SET_ROLE(‘READONLY’) ; END; / Which three statements correctly describe the Secure Application role definition?()
A、No user or application has to remember or hide a password.
B、It prevents everyone except a true DBA session from acquiring the READWRITE role.
C、app.chk_readwrite is called whenever a user tries to access rows protected by the READONLY or READWRITE label.
D、app.chk_readwrite is called by users or applications when they want to enable the READONLY or READWRITE role.
- A,B,D
关注下方微信公众号,在线模考后查看
热门试题
- Which two statements
- Your database&
- What is true about t
- Youissuedthefollowin
- Given: Which t
- In which cases is re
- Which three statemen
- A databaseQ
- You need to create
- ()is a c
- You executed&e
- You are i
- Which are /SQL*Plus
- You work
- he Dynamic&ensp
- At database
- The DB_BLOCK_C
- You issue the follo
- Which three statemen
- Examine the data fr