Grant Role Create Table on a schema deny other schema (Network Steve Forum)

Grant Role Create Table on a schema deny other schema

Hi,

How do I assign a role (Moon_Table_Designers) the ability to create new tables in a schema (Orbits) but ensure that they cannot create tables in other schemas in the database?

This is the practice lab from 70-462: Chapter 6 Lesson 1.

Cheers,

PeiWai

April 7th, 2013 5:45am

Sorry, cannot test it right now

GRANT ALTER ON SCHEMA::Orbits TO Moon_Table_Designers

Free Windows Admin Tool Kit Click here and download it now

April 7th, 2013 5:56am

USE [Saturn]
GO
CREATE ROLE [Moon_Table_Designers];
GO
GRANT CREATE TABLE TO [Moon_Table_Designers]
GO
GRANT ALTER ON SCHEMA::[Orbits] TO [Moon_Table_Designers]
GO

April 5th, 2015 7:05am

This topic is archived. No further replies will be accepted.