"termoPilucco" <termop3141927_at_hotmail.com> wrote in message news:<c60694$69fcj$1_at_ID-188026.news.uni-berlin.de>...
> Hello,
> I have two users, 'ANAG' and 'TEST'.
> Each user has default tablespace with same name of the user itself.
> I.e. user 'ANAG' has 'ANAG' as default tablespace.
> I have a table ANAG.users and i want to grant all permission to user TEST.
> Entering in SQLplus, with user id "ANAG" i can easily solve my problem using
> 'grant all on ANAG.users to TEST;'
> The real problem is i have to do the same through user 'system', because i
> have to run a very long script with system privileges.
> I also tried to change session with ALTER SESSION SET CURRENT_SCHEMA =
> "ANAG" before execute my grant statement, but unsuccessful.
> There is any way to do, or can someone suggest any workaround?
In 9i and up, SYSTEM should be able to do this.
Any account with the new 'GRANT ANY OBJECT PRIVILEGE' can grant
permissions on someone else's objects. What version are you running?
--
Joe
http://www.cafeshops.com/joekaz
http://www.joekaz.net
Received on Tue Apr 20 2004 - 06:57:32 CDT
