I have revoked create table from all schemas but how to revoke alter and drop table. I granted roles connect,resource to schema and revoked create table from them. I grant create table to schema when required. I tried from dba studio but failed. Please help. drop any table and alter any table are the privileges. These are not granted to schema but the guys and gals can alter and drop tables as of now.