Alter Table Permit For Free

If you really want to control this at the object level, you can do:GRANT SELECT,UPDATE,INSERT,DELETE ON dbo. table TO user;GRANT SELECT,UPDATE,INSERT,DELETE ON SCHEMA::dbo TO user;GRANT EXEC ON dbo. procedure TO user;GRANT EXEC ON SCHEMA::dbo TO user;Jun 18, 2012

Granting a Privilege to all Users in a Table: To Grant a specific privilege to all the users in a table users, the following Grant statement should be executed. GRANT SELECT ON Users TO ''@'localhost; In the above example the symbol is used to grant select permission to all the users of the table users.

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Some statements cannot be rolled back. In general, these include data definition language (DDL) statements, such as those that create or drop databases, those that create, drop, or alter tables or stored routines.

I am sorry to have to inform you, but ALTER TABLE cannot be rolled back. In fact, ALTER TABLE triggers an implicit commit. In your case, the ALTER TABLE will either finish or you will have a temp table left hanging around.

For the GUI minded people, you can:Right click the Database in Management Studio.Choose Properties.Select Permissions.If your user does not show up in the list, choose Search and type their name.Select the user in the Users or Roles list.In the lower window frame, Check the Select permission under the Grant column.Sep 1, 2009

Yes, it is possible to use many ALTER TABLE statements in one transaction with ROLLBACK and COMMIT .