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.