Developer has permission issue when attempting to specify any other SCHMEA name except the default DBO schema.

Question

Developer has permission issue when attempting to specify any other SCHMEA name except the default DBO schema.

Welsh Corgi

SSC Guru

Points: 116520
More actions
March 1, 2012 at 7:40 am

#251633

I created a Login for a Developer on a Server and Granted him dbcreator and bulk admin but he can create schema other than the default dbo.
Any help would be appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Ant-Green SSC Guru Points: 113565 More actions · Answer 1

Sorry Corgi, maybe its me reading the thread wrong.

Is the problem that he can create other schemas and objects? Or is the problem that if they try to select from REPORTS.ReportDetails for example it returns an error?

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Sorry the Developer has a permission issue when attempting to create objects in a SCHMEA other than the default DBO schema.:-)

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ant-Green SSC Guru Points: 113565 More actions · Answer 3

I would say have they created the schema? or has something gone funny with permissions when the db was created?

i've just tested this on my test bed and working as expected

new user AntTest with dbcreator and bulkadmin,

logged in as AntTest

created database AntTest

created schema ant with authorisation dbo

created schama ant2 without saying authorisation dbo

created table ant.test and ant2.test

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

Msg 2760 The specified schema name "HisSchema" either does not exist or you do not have permission to use it.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ant-Green SSC Guru Points: 113565 More actions · Answer 5

They have created the schema right? Also for some reason db_owner hasnt been removed as it? Shouldnt of as they created the DB and with dbcreator should get db_owner.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

Thanks for your reply.

I gave him the statement to create the Statement and it worked. I'm just getting hit with a bunch of request at once.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/