Internal can't grant basic permissions on a table

From: William R. Mussatto <mussatto_at_earthlink.net>
Date: Thu, 29 Oct 1998 10:06:54 GMT
Message-ID: <36383673.64969823@news.earthlink.net>

Oracle 8.0.3 evaluation version on NT.
Created new database.
As internal did the following:
- In that database created new user WEB and assigned CONNECT and
RESOURCE roles to it.
- Using scema tool created tables under web

Discovered WEB unable to insert,select,update, delete rows in tables. Of course WEB doesn't have permissions. Went to security tool and as INTERNAL tried to grant WEB object permissions. ERROR: INTERNAL doesn't have the right to grant these permissions on the table.

Ok, I'm being stupid, what did I do wrong?

Bill Mussatto Received on Thu Oct 29 1998 - 04:06:54 CST