permissions

I am working http location and using sql server 2005 ,it is showing an error as " DELETE permission denied on object 'CourseDetails', database 'LOGIN', schema 'dbo'." CourseDetails is my table name and LOGIN is my database name.

Goto SQL Server Management Studio 2005--> Goto your database (LOGIN)--> Right click on the table name (CourseDetails)--> Select Properties

There goto the Permissions tab and click add... You can add the permission here...

But the question is WHY would you want to add delete permissions on your SQL Table? What you should do is write a Stored Procedure to delete the data in there and give the procedure execute permissions.

|||

Thank u deepak

Permission denied trying to delete user

Hi,
iam ratnesh and want to delet the user which is created in database, it gives me error that selected cannot be droped because the user owns object, pls help me to resolve the problem.

Regards[First use sp_changeobjectowner to convert the ownership to dbo from that user and then drop the unwanted user.