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: Internal can't grant object permissions

Re: Internal can't grant object permissions

From: Quinton McCombs <quintonm_at_bellsouth.net>
Date: Fri, 30 Oct 1998 18:52:19 GMT
Message-ID: <363A0AFF.49992CF7@bellsouth.net>


The WEB user will have all rights to objects owned by WEB. In Oracle, you need to be logged into the database as the user to grant rights on that user's objects to others.

"William R. Mussatto" wrote:
>
> Thought I sent this in already, but it didn't show up.
>
> System Oracle 8.0.4 evaluation version (its failing!).
> WinNT 4.0 SP3 IE 4.x (because bill can't tell the difference between
> an OS and an app).
>
> Created new database. Created user WEB
> As INTERNAL using the GUI scema editor created several tables "under
> WEB".
> Using security tool tried to grant object permissions to WEB to
> INSERT, DELETE, SELECT, UPDATE these tables. Error: insufficient
> permissions. If INTERNAL can't do it, who can? Think I also tried a
> SYS with same results.
>
> HELP, I'm probably doing something stupid, but...
>
> Bill Mussatto
Received on Fri Oct 30 1998 - 12:52:19 CST

Original text of this message

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