Jaap Karman, Thank you so much for your prompt response,I appreciate it. actually I gave full permissions except delete permissions to that user on that library and table also from SAS Management console. but when he tried to open that dataset in the oracle library it has thrown with below error in a pop-up window with name "Data grid error" An unexpected error occured while attempting to read the data values.Do you wish to retry or cancel ? System.IndexoutofRangeException: Index was outside the bounds of the array. at SAS.EG.DataAccess.DataModel.DmSasRioPageBuffer.Populate(Int32 startingRecordNumber,DataAccessor dataAccessor,Double[,] numericColValues,String[,] characteColValues) at SAS.EG.DataAccess.DataModel.DaForSasData.BufferData(Int32 startRecord,Boolean formatted,Double[,] numColValues,String[,] charColValues). at SAS.EG.DataAccess.DataModel.DaForSasData.CommomReadPage(Int32 record,Boolean formatted,Int32 readFlags,Int32 offset,Byte[] positionBookmark,Byte[] & bookmarks,Int32& recordRead) --------------------------- ----------------------- ----------------------- Error follows like this...did'nt typed complete error and I suggested to run libname statement of that oracle library from his EG 5.1 and try opening the dataset again,but it has thown below error. “ERROR: ORACLE connection error: ORA-01017: invalid username/password; logon denied. ERROR: Error in the LIBNAME statement.” but i can able to open that dataset and i can run libname statement successfully. what are all the reasons for getting this type of error and what are all the comman and possible options we have to trouble shoot this kind of error,please suggest.I would really appreciate your help.
... View more
