>>>>In a research process, a graduate student was not able to run the SQL PLus p

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 violati.on. 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

Report :

1. Provide the file name of the executable file for Oracle SQL Plus in your computer system.

2. Provide a location or folder name from your computer system for the file.

3. Provide screen shots to prove that you are able to change the file attributes for the above task.

Explanation / Answer

The file that runs the SQL Plus in the system can be located by running the following command in UNIX: root> which sqlplus

Connect to the Oracle server as the SYSTEM account, since the SYStem account is capable of many administrative tasks.

After creating the account, create a user using CREATE USER command. For example,

CREATE USER abc IDENTIFIED BY pass

Here, the username is abc and password is pass.

After creating a user, use the GRANT command to grant privileges. You can use the below command to grant any privileges.

GRANT ANY PRIVILEGES TO abc.

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.