• Your best bet would probably be to make the user dbo, however it depends on the permission requirements of your particular db.

    If you would like to grant the permissions explicitly the syntax is as below:

    GRANT CREATE FUNCTION TO [YourUser];

    GRANT CREATE TABLE TO [YourUser];

    etc...

    Andreas Goldman