Dev @ SEA
Software solutions.
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
]
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)