Home Forums SQL Server 2008 SQL Server 2008 Administration Can DDL Admin be assigned at the schema level instead of the DB level? RE: Can DDL Admin be assigned at the schema level instead of the DB level?

  • March 17, 2011 at 3:30 pm

    #1300259

    Thanks Jim!

    That led to

    "GRANT Database Permissions (Transact-SQL)" http://msdn.microsoft.com/en-us/library/ms178569.aspx

    which by far was the simplest answer.

    Was not familiar with the granularity available (and it helps to know how to ask the correct question). :w00t:

    Thanks again - Joe