Granting permission to create tables
USE AdventureWorks;
GRANT CREATE TABLE TO MelanieK;
GO
Granting SHOWPLAN permission to an application role
USE AdventureWorks2012;
GRANT SHOWPLAN TO AuditMonitor;
GO
Granting CREATE VIEW with GRANT OPTION
USE AdventureWorks2012;
GRANT C...
