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

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy