The old hack is via definers rights procedures
(as SYS etc)
create or replace
procedure THE_OWNER.do_sql(m varchar2) is
begin
execute immediate m;
end;
exec THE_OWNER.do_sql('grant ...');
drop procedure THE_OWNER.do_sql
hth
connor
- Jared Still <jkstill_at_cybcon.com> wrote: >
> That won't give SYS the privileges you think it
> does.
>
> For any user, including SYS, to be allowed to grant
> direct
> privileges on another users objects, that user must
> have
> explicity direct grants with the 'with grant
> option'.
>
> e.g. to allow SYS to grant privileges on the table
> EMP
> owned by SCOTT, you must log in as SCOTT and issue
> this command:
>
> GRANT ALL ON EMP TO SYS;
>
> The user SYS will now be able to grant privilege on
> SCOTT.EMP
> to other users.
>
> Jared
>
> On Friday 19 April 2002 19:23,
> com.banilejas_at_codetel.net.do wrote:
> > Hi gurus,
> >
> > I created a script to assign some grants
> automatically to some roles and
> > users.
> >
> > As the user sys, I assigned to user system the
> GRANT ANY PRIVILIGE, GRANT
> > ANY ROLE, roles and when run the script get the
> error of insufficient
> > privileges.
> >
> > What I dont want is to connect to each user to
> apply the grants.
> >
> > How can achieve that ?
> >
> > TIA
> >
> > Ramon
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Apr 22 2002 - 05:43:19 CDT