Q: Privileges and WOW

From: Ron Levenberg <ral_at_cc.bellcore.com>
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

Original text of this message