Working with security in SQL Server 2008, I'm trying to grant a user CREATE TABLE permissions, but only within a specific schema. Does CREATE TABLE permission only apply at the database level?
Can I limit the user to create table only within a schema?
I've tried:
USE [databasename]
GRANT CONTROL ON Schema :: [schemaname] TO [username]
GO
and
USE [databasename]
GRANT ALTER ON Schema :: [schemaname] TO [username]
GO
But, the user is still unable to create a table within the target schema. It's not until I run this, hat the user can create a table:
USE [databasename]
GRANT CREATE TABLE to [username]
GO