Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Run SQL Script under SYS for other Schema

Re: Run SQL Script under SYS for other Schema

From: Joel Garry <joel-garry_at_home.com>
Date: 8 Jan 2004 15:15:57 -0800
Message-ID: <91884734.0401081515.65dc797d@posting.google.com>

jeffl_at_hypershell.com (Jeff Lambert) wrote in message news:<f17e7766.0401080750.283dfdb9_at_posting.google.com>...
> Using Oracle 8i on Win2k. Here's my problem:
>
> I can connect with SYS and can select from any table from schema JEFFX
> by prefixing tables with said schema name. eg: SELECT * FROM
> JEFFX.PROJ;
>
> However I want to run a "recompile all invalid objects" script on my
> JEFFX user / schema. Namely, RDBMS\ADMIN\utlrp.sql. Running it under
> SYS yields no errors. When I try to run it when connected as JEFFX, I
> get errors such as:
>
> PLS-00201: identifier 'OBJ$' must be declared
>
> The user JEFFX has very limited rights indeed and that's how I want to
> keep it. I want to be able to run the script under SYS but for the
> JEFFX schema. I tried this command:
>
> ALTER SESSION SET CURRENT_SCHEMA = JEFFX;
>
> But it doesn't do much it seems? In fact it's like I'm back to using
> the stripped down user, right? I'm sure there's a very simple
> explanation to this. I'm also willing to add the required right to
> this user provided it doesn't turn him into a full blown DBA.
>
> Thanks in advance!
>
> Jeff Lambert
> Hypershell, Inc.

Note this group has been superceded by comp.databases.oracle.* (where * is server for this type of question).

http://download-west.oracle.com/docs/cd/A87860_01/doc/index.htm

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=9q9fg30bbb%40drn.newsguy.com

jg

--
@home.com is bogus.
http://www.automobilemag.com/auto_shows/04det_chevcorvette/
Received on Thu Jan 08 2004 - 17:15:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US