RESOURCE authority is the permission to create database objects, such as tables, views, and stored procedures. Only a user with DBA or PERMS ADMIN authority may grant RESOURCE authority to other users.
