$ORACLE_HOME/sqlplus/admin/pupbld.sql
PRODUCT_USER_PROFILE
PRODUCT_PRIVS
create table sqlplus_product_profile ( product varchar2 (30) not null, -- Or varchar2(128) userid varchar2 (128), attribute varchar2 (240), scope varchar2 (240), numeric_value decimal (15,2), char_value varchar2 (240), date_value date, long_value long );
create view product_privs as select product, userid, attribute, scope, numeric_value, char_value, date_value, long_value from sqlplus_product_profile where userid = 'public' or userid like sys_context('userenv','current_user');
-restrict
$ORACLE_HOME/sqlplus/admin
Index