题目内容
YouarepartoftheDBAteamworkingforamultinationalbank.Theteamisresponsibleforperformingadministrativetasksonthedatabaseserverlocatedatthehomeoffice.ThedatabaseserveratthehomeofficehasaproductiondatabaseandatestdatabasenamedTESTDB.Thetestdatabaseisprimarilyusedfortestingdatabasecommandsandconfigurationsettingsbeforimplementingthesesettingsontheproductiondatabase.Thetestdatabaseisalsousedforthedevelopmentofdatabaseapplications.YouhavebeenaskedbytheseniorDBAtogranttheSYSDBAprivilegetoanewteammember,John,sothathecanperformsomeadministrativetasks,suchasshutdownandstartupoperations,onTESTDB.YouusethepasswordfiletoconfigureremoteauthenticationontheTESTDBdatabase.Youexecutethefollowingstatementtograntthe SYSDBAprivilegetoJohn:
SQL>GRANTSYSDBATOjohn;
However,youreceivethefollowingerror:
ORA-01996:GRANTfailed:passwordfile
’c:\oracle\ora9i\dbs\testdb.pwd’isfull
Whichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers?()
查看答案
搜索结果不匹配?点我反馈