1)创建用户sec SQL> create user sec identified by sec; User created. 2)授权 SQL> grant connect,resource to sec; Grant succeeded. 3)错误在此发生 SQL> conn sec/sec Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as S...
DROP SYNONYM PRODUCT_USER_PROFILE * 第1 行出现错误: ORA-01434: ??? DATE_VALUE FROM PRODUCT_USER_PROFILE * 第3 行出现错误: ORA-00980: ??? DROP TABLE PRODUCT_USER_PROFILE * 第1 行出现错误: ORA-00942: ??? ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG) * 第1 行出现错误:...
Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM 其实在实际意义上这只是一个警告而已,并不是真正的错误,遇到这个提示,并不会影响我们正常使用SQL*Plus,也不会对数据库功能产生影响。 如果数据库是使用dbca创建的那么不用担心...
Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected. SQL> conn system/d2nb51tz Connected. SQL> @pupbld ... SQL> conn test/test Connected. /*重新执行pupbld.sql脚本后登录恢复正常 */ 1. 2. 3. 4. ...
错误集合总结: SQL> conn scott/tiger; Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected. 发生上面的错误 执行$ORACLE_HOME/sqlplus/admin/pupbld.sql文件 ...
Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM PRODUCT_USER_PROFILE是Oracle 10g中一个用来显示记录那些不希望用户可以在sqlplus执行命令的权限表,该表一般会在数据库创建时在system模式下被建立;显然用户的这个数据库可能是以...
访问PRODUCT_USER_PROFILE 时出错 警告: 未加载产品用户概要文件信息! 您需要将 PUPBLD.SQL 作为 SYSTEM 运行 已连接。 错误提示也很明显就是使用system用户运行PUPBLD.SQL 脚本 SYS@icsdb >conn system 输入口令: 已连接。 SYSTEM@icsdb >@?/sqlplus/admin/pupbld.sql ...
访问PRODUCT_USER_PROFILE 时出错 警告: 未加载产品用户概要文件信息! 您需要将 PUPBLD.SQL 作为 SYSTEM 运行 已连接。 错误提示也很明显就是使用system用户运行PUPBLD.SQL 脚本 SYS@icsdb >conn system 输入口令: 已连接。 SYSTEM@icsdb >@?/sqlplus/admin/pupbld.sql ...
Chapter 13. The Product User Profile In addition to the standard database security Oracle provides and enforces for all database objectsâtables, views, and the likeâOracle provides an application security scheme for SQL*Plus. This allows you to control the specific ...
If you have not set the countries or regions to which your app will be distributed, a message will be displayed, prompting you to select distribution countries or regions for your app. Configure product information and click Save. The following table provides the related parameters. Parameter Desc...