SQL Server schema-owner permissions
Posted
by Andrew Bullock
on Stack Overflow
See other posts from Stack Overflow
or by Andrew Bullock
Published on 2010-05-04T11:21:26Z
Indexed on
2010/05/04
11:28 UTC
Read the original article
Hit count: 301
tsql
|sql-server
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
© Stack Overflow or respective owner
