Q: Privileges and WOW
Date: 1996/01/06
Message-ID: <4cmvg0$ejg_at_athos.cc.bellcore.com>#1/1
I'm trying to install WOW on my HP-UX system. I'm new to Oracle, but have succeeded in creating a table (using a user id of the OPS$xxx type) that I can freely peruse.
First question: When I log in as another user id, that user can't see the table I created. Why?
Second question: When I try to run the ht.sql which creates a package, I get:
[www_at_carib:/users/www/wow] sqlplus /
SQL*Plus: Release 3.1.3.7.1 - Production on Sat Jan 6 18:11:15 1996
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
Connected to:
Oracle7 Server Release 7.1.6.2.0 - Production Release
PL/SQL Release 2.1.6.2.0 - Production
SQL> start ht.sql
Package htf...
create or replace package htf as
*
ERROR at line 1:
ORA-01031: insufficient privileges
[and so on ...]
What do I need to do to fix the problem?
Thanks.
Ron Levenberg - ral_at_cc.bellcore.com Received on Sat Jan 06 1996 - 00:00:00 CET