AdatabaseuserSMITHtriestoquerytheV$SESSIONviewandfailstoaccessitasfollows：SQL>connectsmith/smithConnected.SQL>SELECT*FROMv$session；SELECT*FROMv$session*ERRORatline1：ORA-00942：tableorviewdoesnotexistWhicharethetwopossiblesolutionstoenableSMITHtoquerythedat
题目
AdatabaseuserSMITHtriestoquerytheV$SESSIONviewandfailstoaccessitasfollows：SQL>connectsmith/smithConnected.SQL>SELECT*FROMv$session；SELECT*FROMv$session*ERRORatline1：ORA-00942：tableorviewdoesnotexistWhicharethetwopossiblesolutionstoenableSMITHtoquerythedatainV$SESSION（）
A.grantingSELECTprivilegetoSMITHonV$SESSION
B.grantingSELECTprivilegetoSMITHonV_$SESSION
C.askingtheuserSMITHtorunthecatalog.sqlscript
D.grantingSELECTprivilegetoSMITHonV$FIXED_TABLES
E.settingtheO7_DICTIONARY_ACCESSIBILITYparametertoTRUE
F.creatingaviewbasedonV$SESSIONandgrantingSELECTprivilegetoSMITHontheviewthatwascreated