• The question is how do I set up a role that allows table creation in a given schema in this case AS400 but not dbo, as the script above does not achieve this

    Is it possible ?

    Thanks