957884 wrote:Only when directed by Oracle to do so; otherwise NEVER
Hi to all,
I got the difference between the two users of sys and system from above part.
Thanks for your Information
But can any one clarify when and in which situations we connect to system user to perform?
Thanks for reply....
I hope the answer for below question also...
"Why we need to run pupbld.sql script as system? Is there any reason behind it?"
Thanks & Regards
Because Oracle Says to do so; see above!
[oracle@localhost ~]$ more /home/oracle/app/oracle/product/11.2.0/dbhome_2/sqlplus/admin/pupbld.sql -- -- Copyright (c) Oracle Corporation 1988, 2003. All Rights Reserved. -- -- NAME -- pupbld.sql -- -- DESCRIPTION -- Script to install the SQL*Plus PRODUCT_USER_PROFILE tables. These -- tables allow SQL*Plus to disable commands per user. The tables -- are used only by SQL*Plus and do not affect other client tools -- that access the database. Refer to the SQL*Plus manual for table -- usage information. -- -- This script should be run on every database that SQL*Plus connects -- to, even if the tables are not used to restrict commands. -- USAGE -- sqlplus system/<system_password> @pupbld -- -- Connect as SYSTEM before running this script