SQL Server schema-owner permissions
- by Andrew Bullock
if i do:
CREATE SCHEMA [test] AUTHORIZATION [testuser]
testuser doesn't seem to have any permissions on the schema, is this correct? I thought as the principal that owns the schema, you had full control over it?
What permission do i need to grant testuser so that it has full control over the test schema only?
Edit: by "full control" i mean the ability to CRUD tables, views, sprocs etc
Thanks