Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insufficient Privileges Creating Tables / Sequences / Triggers

Re: Insufficient Privileges Creating Tables / Sequences / Triggers

From: Hoang-Vu PHUNG <hoang-vu_at_freesurf.ch>
Date: Fri, 10 Dec 1999 14:45:59 +0100
Message-ID: <82r064$dh4$1@news1.sunrise.ch>


alter any table is is used to modify the structure of your tables and not intended to
create trigger or table etc...
Cheers
<john_galt29_at_my-deja.com> wrote in message news:82qteh$qf5$1_at_nnrp1.deja.com...
> Actually this is a follow up to a previous message, about "Who is the
> database user when you login from the web?" Well I have looked through
> my Web Admin pages and found out we only have two users. Both of these
> users have ALTER ANY TABLE access and yet when I go to create a trigger
> (and another user, on a very similar system when he tries to create ANY
> object, table, sequence or trigger using the same script ...) I get an
> error, ORA-01031: insufficient privileges.
>
> I just don't get it! I logged in as system and gave ALTER ANY TABLE
> privileges directly to both DB users and yet I still have this error.
>
> I don't know ... I read in a tech bulletin that when you use DBMS_SQL
> any privileges granted through roles don't apply, that you have to
> grent the access directly. Well I DID that! It seems to me that this
> error is not accurate, that it's impossible that it's an access issue!
>
> Anyone had this problem? I would really appreciate some help!
>
> Thanks!
> John
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 10 1999 - 07:45:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US