August 18, 2011 at 7:19 am
I am facing an issue with allocating default database for a windows group when i add this group as a login in sql server 2005.
whenever a new object is getting created by the member of this group, it is creating with its own schema rather than with dbo.
August 18, 2011 at 7:25 am
unable to assign default schma as dbo in sql server for a sql server group alongside a database name.
August 18, 2011 at 7:30 am
When setting the default schema did you use the GUI or did you run the Alter User command?
Additionally the users can specify the schema...create table dbo.xyz
August 18, 2011 at 7:33 am
Using GUI.
And I do not want the users to specify like dbo.
For windows logins it is working but for a windows group it does not.
August 18, 2011 at 7:37 am
Try using t-sql to change the schema....it may not make a difference. I only use groups and all my groups use dbo and I force them to specify the schema if it is something other than that.
ALTER USER [GroupName] WITH DEFAULT_SCHEMA = dbo;
August 18, 2011 at 7:52 am
The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys.
August 18, 2011 at 8:03 am
What happens if you try to drop the groups schema? Assuming it is not going to be used.
August 18, 2011 at 8:36 am
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply