How to prevent remote login for SYS

up vote 5 down vote favorite

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

edited Jan 7 at 13:22

Starfish
603416

asked May 5 '11 at 16:37

schurik

feedback

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

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

1 Answer

active oldest votes

up vote 8 down vote

Set the system parameter

ALTER SYSTEM SET remote_login_passwordfile = NONE SCOPE=SPFILE;

Then restart the database.

answered May 5 '11 at 16:48

DCookie
1,748511

feedback