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.
Thursday, May 28, 2009
Subscribe to:
Posts (Atom)