Re: insufficient priviliges

On 12 Jul 2006 15:49:32 -0700, "newbie" <rjngh2005_at_gmail.com> wrote:

>Oracle Version 8.1.7.4.1
>
>Yes, The changing password method is my last resort.
>
>I would like to attempt any other method to enable either user sys or
>system
>to grant permission to user test select permission to objects of schema
>abc
>
>Thanks.....I look forward to more suggestions

First suggestion: stop top-posting
Second suggestion : stop top-posting
Third suggestion: Always mention your version in order to avoid wasting people's time, as in 8i you can't use David Fitzjarell's suggestion.

There is a very nasty tric to help you do it.

As sys or system
create or replace procedure <table_owner>.do_sql(sqlstr in varchar2) is
begin
execute immediate sqlstr;
end;
/

Now as sys or system
execute <table_owner>.do_sql('grant .... etc')

Works like a charm, and demonstrates whoever know the SYS or SYSTEM password (or any other privileged account) can control the entire database.

--
Sybrand Bakker, Senior Oracle DBA