I am preparing a database for a vendor system to be installed. The requirements say to create a database and a login with a user on that database. Easy enough.
Next they want a schema created, and the user should be granted "create/delete/alter database objects" within the new schema only. I am not seeing how I can grant those privileges to the user within the schema only. Any suggestions on how to do this? I've granted plenty of permissions over the years but have never had a requirement within a schema like this. Any help would be much appreciated. Thank you!