How to set the SQL *Plus banner as in below image.?
Append below lines to $ORACLE_HOME\sqlplus\admin\glogin.sql
SELECT 'This system is for the use of authorized users only. Individuals using this computer system with authority, without authority, or in excess of their authority, are subject to having all of their activities on this system monitored and recorded by system personnel. In the course of monitoring individuals improperly using this system, or in the course of system maintenance, the activities of authorized users also may be monitored. Anyone using this system expressly consents to such monitoring and is advised that if such monitoring reveals possible evidence of criminal activity, system personnel may provide the evidence of such monitoring to law enforcement officials and will result in prosecution to the maximum extent allowable by applicable law.' "********** WARNING ***********" FROM dual;
Append below lines to $ORACLE_HOME\sqlplus\admin\glogin.sql
SELECT 'This system is for the use of authorized users only. Individuals using this computer system with authority, without authority, or in excess of their authority, are subject to having all of their activities on this system monitored and recorded by system personnel. In the course of monitoring individuals improperly using this system, or in the course of system maintenance, the activities of authorized users also may be monitored. Anyone using this system expressly consents to such monitoring and is advised that if such monitoring reveals possible evidence of criminal activity, system personnel may provide the evidence of such monitoring to law enforcement officials and will result in prosecution to the maximum extent allowable by applicable law.' "********** WARNING ***********" FROM dual;
Note:
This glogin.sql will be invoked immediately after connecting to database.
This sqlplus\admin\glogin.sql file should be available in Oracle database home and Oracle client home too.
Oracle express client may not have sqlplus\admin\ directory.
No comments:
Post a Comment