Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to prevent the remote logins for the SYS user? Oracle 10g.

share|improve this question

migrated from stackoverflow.com May 9 '11 at 18:50

This question came from our site for professional and enthusiast programmers.

Set the system parameter

ALTER SYSTEM SET remote_login_passwordfile = NONE SCOPE=SPFILE;

Then restart the database.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.