Re: Grant problem

Yes, sure
1 fire the DBA who doesn't know the only way to get around this is connect as the owner and issue a grant on table to xxxx with grant option 2 have him

   select username, password
   from dba_users where username = 'yyyy'    and spool it to a file
3 have him execute the command under 1
4 alter user yyy identified by values 'the password string gotten in step 2'

Hth

--
Sybrand Bakker, Oracle DBA

Christian Jepsen <CRJ_at_kmd.dk> wrote in message news:01beffbb$aeb33560$4c1414ac_at_h-11489...
> Hi
> I have a DBA Consult with a private login name xxxxx he have
> been granted the dba role.
> Now he create a table in another schema yyyyy, ok so far, but
> now he want to
> grant select,insert,update,delete on yyyy.table to zzzz
> When he try this he get : ORA-01031: insufficient privileges
>
> I have tried to grant him every rights i could find but no luck so far.
>
> Any suggestions ???
>
> Thanks Christian Jepsen.
Received on Wed Sep 15 1999 - 16:15:05 CDT