Hi..,
I've created a user that Test

Provided the following:
Grant connect,resource to test;

RESOURCE Role is a set of the following privileges:
Note :I've checked it using the query "select * from dba_sys_privs where grantee='RESOURCE'"

CREATE TRIGGER
CREATE SEQUENCE
CREATE TYPE
CREATE PROCEDURE
CREATE CLUSTER
CREATE OPERATOR
CREATE INDEXTYPE
CREATE TABLE

Without ALTER TABLE Privilege how can I able to Altering my table which is exists in test User..?
Can u pl. explain..?

Thanks in Advance,
Giri K.Y.