anjan.ashok (10/7/2008)

---

hi dugi

one problem delete permission is restricted but the testuser can drop the table

any idea how to fix this issue?

DELETE PAYROLL
WHERE No = 2;

MSG:
Msg 229, Level 14, State 5, Line 1
The DELETE permission was denied on the object 'Payroll', database 'TEST', schema 'dbo'.

DROP TABLE PAYROLL;
GO

MSG:
Msg 3701, Level 14, State 20, Line 4
Cannot drop the table 'Payroll', because it does not exist or you do not have permission.

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:)

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