in a research process, a graduate student was not able to run the SQL PLus progr
ID: 3743615 • Letter: I
Question
in a research process, a graduate student was not able to run the SQL PLus program from Oracle for Windows. The database software was installed successfully under Windows XP Pro. When he was trying to execute the SQL Plus link, the program just closed automatically. After some research, it was identified that the problem was caused by file permission violation. In other words, the login user did not have full control on the file. Now, I am asking you to help resolve the problem, with the following tasks.
>Find the file that runs SQL Plus in your system.
>Locate the directory or folder where the above file resides.
>Illustrate a way to allow full access/control to you as a Oracle user.
Explanation / Answer
Answer)
The file which would run the SQL Plus in one's system is with the extension .sql and can run SQL Plus statements which are stored in a file. Also note that these commands which are to be executed are stored in the SQL Buffer which can either run one statement or even run a complete procedure.
Some of the command which can be used for storing the details in the file are as follows, :
The file with the extension can be saved any where in the system which will be accessible and file can be detected.
Below is the command to be used to grant access as Oracle user :
FULL priviledge is the command which would help. Also this is similar to READ except for the fact that it helps to update and read the algorithms. All the relevant data can b saved and written to the system with respect to scripts and to grant full access the above command is to be used.
Hope you like the answer. :)
Hit like if you find the answer useful. Thanks
@ { url | filename [ .sql ] } [ arg... ] START filename [ .sql ] [ arg... ] Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.