Thursday, May 28, 2009

Grant Alter.....

There are two commands quite similar:

Grant Alter to User1
Grant Alter on Table1 to User1


Grant Alter allows User1 to make any change - modify, create and drop - to the current database whereas Grant Alter On Table limits the privilege to just change the schema of Table1 - User1, however, cannot drop the table in the latter.