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?
USE [databasename] GRANT CONTROL ON Schema :: [schemaname] TO [username] GO
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