THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

DCL clauses in CREATE SCHEMA

This blog has moved! You can find this content at the following new location:

http://greglow.com/index.php/2011/06/01/dcl-clauses-in-create-schema/

Published Wednesday, June 1, 2011 7:58 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Uri Dimant said:

Hi Greg,

Should CREATE TABLE permission be granted?

CREATE LOGIN test_login WITH PASSWORD = 'jj'

CREATE USER test_login

FOR LOGIN test_login WITH DEFAULT_SCHEMA = test_loginSchema

CREATE SCHEMA test_loginSchema AUTHORIZATION test_login

EXECUTE AS User='test_login'

CREATE TABLE test_loginSchema.tb(id int)

--Msg 262, Level 14, State 1, Line 1

--CREATE TABLE permission denied in database 'db1'.

June 1, 2011 2:45 AM
 

Uri Dimant said:

Hi Greg,

Should CREATE TABLE permission be granted?

CREATE LOGIN test_login WITH PASSWORD = 'jj'

CREATE USER test_login

FOR LOGIN test_login WITH DEFAULT_SCHEMA = test_loginSchema

CREATE SCHEMA test_loginSchema AUTHORIZATION test_login

EXECUTE AS User='test_login'

CREATE TABLE test_loginSchema.tb(id int)

--Msg 262, Level 14, State 1, Line 1

--CREATE TABLE permission denied in database 'db1'.

June 1, 2011 2:45 AM
 

Greg Low said:

Hi Uri,

Not sure I follow the question. I'm talking about the clauses within the CREATE SCHEMA statement, not separate CREATE TABLE or GRANT statements.

June 1, 2011 3:10 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement