Hi
We have a stored proc which we are using which creates a table, we are running with a WITH EXECUTE AS as the user does not have rights to create tables. This is working perfectly. The user mentioned in the WITH EXECUTE AS has dbo_owner rights. We now have the issue that the user also needs to grant access to the new table, there is a right on a database db_accessadmin, is this really safe to use.
What are the ideal rights for the user, it needs to rename, create, add pk and fk, indexes etc as well as grant access to tables. I am just unsure of giving it db_owner and db_accessadmin rights