grant object privilege

I'm an Oracle newbie that would like some feedback on whether I'm misinterpreting command syntax. We are running Oracle 7.3.2 on an NT platform.

I created a role to support all users logging into the application [the app will issue a SET ROLE MYROLE]. I created a new user, connected as that user and ran script to add a set of application tables.

To grant the ROLE privileges, I am attempting to use the following generic form of grant [object] privilege [to avoid having to issue a grant for every table]. It is not working: says I don't have the right privilege. grant DELETE to MYROLE [my presumption is, since I connected as that user, any grant that did not refer to a specific object would default to all objects for that users schema. Is this faulty logic, or am I missing something else???].

Note, when I issue grant DELETE on USER_TABLE_A to MYROLE the command is accepted with no nasty messages.

I know that I can generate the script by table easily by fabricating a slect and turning that back to an SQL session, but if I can use a generic command, it will be cleaner to document [ did I really say DOCUMENT?? wow, must be tired!!].

Anyway, I would appreciate someone pointing the error of my ways or suggesting something I am overlooking.
TIA.........JJD Received on Thu Nov 06 1997 - 00:00:00 CST