December 16, 2010 at 3:46 pm
Hi,
I need to create 10 different user schemas in SQL Server 2008 in one database and those 10 users will need to create their own tables, procedures etc?
Could you please advice me how to achieve this?
Thanks
December 16, 2010 at 8:29 pm
Quick Google/Bing search will bring you to this BoL article
Links at the bottom for the commands. However you can also use the GUI wizard through SSMS if you prefer.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
December 29, 2010 at 11:20 am
Thanks. I need to create 2 schemas for 2 users, for example Matt and scott naming the schemas as Matt and scott and then allow them to create their own objects in their respected schemas
And do we need to create the Logins for the 2 users and map the database in which we are creating the shcemas?
December 29, 2010 at 11:44 am
You can create them in either sequence. Schema first or login first. Works the same either way, just changes some of how you write the commands.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply