"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?
connect as anag in your script?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Mon Apr 19 2004 - 05:54:06 CDT
