anjan.ashok (10/8/2008)
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:)
Ok you have also these options:
use [TEST]
GO
GRANT ALTER TO [Your_User]
GO
use [TEST]
GO
GRANT CREATE TABLE TO [Your_User]
GO
use [TEST]
GO
GRANT CREATE VIEW TO [Your_User]
GO
The last one is also to create the view!