Topic: SQL*Plus and PL/SQL >> Database !
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| seema |
Posted: Sep 02, 2008 05:10:11 AM |
Total Post: 70
Joined: Jan, 2008
|
| At the time of creation of the database why we connect with system manager for run the pupbld.sql why not sys?????? |
|
|
 vino |
| Posted: Sep 02, 2008 05:32:49 AM |  |
|
Total Post: 357
Joined: Aug, 2008
|
Hi Seema,
Its so simple that the other users won't have the previlage to run that script. Therefore, system user login is needed for that script.
For more info in this topic, visit the below website and search a keyword pupbld.sql:
http://oreilly.com/catalog/orsqplus/chapter/ch09.html
Regards.
|
|
|
|
|
| shake |
| Posted: Sep 02, 2008 05:49:44 AM | |
|
Total Post: 85
Joined: Jun, 2008
|
Could you explain what is this script and its role?.
|
|
|
|
|
| vino |
| Posted: Sep 02, 2008 06:54:58 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
Here are the contents of Oracle's 'PUPBLD.SQL' script:
CODE
-- Copyright (c) Oracle Corporation 1988, 2000. 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
-- If PRODUCT_USER_PROFILE exists, use its values and drop it
DROP SYNONYM PRODUCT_USER_PROFILE;
CREATE TABLE SQLPLUS_PRODUCT_PROFILE AS
SELECT PRODUCT, USERID, ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE,
DATE_VALUE FROM PRODUCT_USER_PROFILE;
DROP TABLE PRODUCT_USER_PROFILE;
ALTER TABLE SQLPLUS_PRODUCT_PROFILE ADD (LONG_VALUE LONG);
-- Create SQLPLUS_PRODUCT_PROFILE from scratch
CREATE TABLE SQLPLUS_PRODUCT_PROFILE
(
PRODUCT VARCHAR2 (30) NOT NULL,
USERID VARCHAR2 (30),
ATTRIBUTE VARCHAR2 (240),
SCOPE VARCHAR2 (240),
NUMERIC_VALUE DECIMAL (15,2),
CHAR_VALUE VARCHAR2 (240),
DATE_VALUE DATE,
LONG_VALUE LONG
);
-- Remove SQL*Plus V3 name for sqlplus_product_profile
DROP TABLE PRODUCT_PROFILE;
-- Create the view PRODUCT_PRIVS and grant access to that
DROP VIEW PRODUCT_PRIVS;
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 USER LIKE USERID;
GRANT SELECT ON PRODUCT_PRIVS TO PUBLIC;
DROP PUBLIC SYNONYM PRODUCT_PROFILE;
CREATE PUBLIC SYNONYM PRODUCT_PROFILE FOR SYSTEM.PRODUCT_PRIVS;
DROP SYNONYM PRODUCT_USER_PROFILE;
CREATE SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.SQLPLUS_PRODUCT_PROFILE;
DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE;
CREATE PUBLIC SYNONYM PRODUCT_USER_PROFILE FOR SYSTEM.PRODUCT_PRIVS;
-- End of pupbld.sql
As you can see from the code that you must run the script as Oracle user, "SYSTEM".
The pupbld.sql script is not run on database creation. IIRC, this script
is run as SYSTEM. If you look at the script, you will see that it
creates a table called PRODUCT_USER_PROFILE. If this table exists, then
you should not need to run the script. If the table does not exist, then
run the script as SYSTEM.
|
|
|
|
|
| seema |
| Posted: Sep 03, 2008 02:29:38 AM | |
|
Total Post: 70
Joined: Jan, 2008
|
thank you....... for the same
|
|
|
|
|
| vino |
| Posted: Sep 03, 2008 03:49:17 AM | |
|
Total Post: 357
Joined: Aug, 2008
|
Still your query not resolved???
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Vinoth Kumar | 357 |
| Gopu Gopi | 340 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
