Thursday, December 3, 2015

Grant permission to create a table in SQL Server. No DDLAdmin

You can set the ability to create a table in a SQL Server database with a grant statement. See here
[Grant Syntax]

You don't have to assign ddladmin privileges.

Thursday, June 11, 2015

Viewing DDL in SQL Server

To provide a read only view of the list and content of the DDL elements (procedures, functions etc) in SQL Server without granting ddladmin use

GRANT VIEW DEFINITION ON SCHEMA::dbo TO [domain\user]