hi Dugi,

Thanks buddy

i added to datawriter role and now drop permission is denied.

One more question?

When i tried to create table ,i am getting following error

Msg 2760, Level 16, State 1, Line 1

The specified schema name "dbo" either does not exist or you do not have permission to use it.

when i tried to alter table i am getting following error

Msg 1088, Level 16, State 13, Line 1

Cannot find the object "test1" because it does not exist or you do not have permissions.

To fix can i assign permissions at the database level or can i do through grant permission i guess its not possible through grant query

pls help me on this.

Thanks,

Anjan:)