472,145 Members | 1,569 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

Problem In Assigning Default Schema To Database User ?

147 100+
Dear All,

I am using SQL Server 2008, I have setup a login user "User1" and next I setup database user using the same user name and login name. After that I create a new schema "mySchema" and make "User1" as the owner of the schema. To "User1" I assigned the default schema to "mySchema", so far its working fine. But when I open the user's property window (dialog box) the default schema always gets reset to "dbo".

What could be the problem here? Please help me if there is any solution to get the right schema which I assigned to the user.

Thanks and regards,
Oct 25 '10 #1
0 1122

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Hemant Shah | last post: by
7 posts views Thread by greatcanyon | last post: by
1 post views Thread by Nalaka | last post: by
4 posts views Thread by bea | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.