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.