Is there anyway to change the default schema for a user who is a
member of "sysadmin". It appears that Microsoft has made the default
schema for this role "dbo" and our application has been writtem not to
include owner/schema name.
Re: Alter User for domain user ... Any member of sysadmin will always be the dbo inside a DB. ... connect to the server with Windows Authentication, the default schema... (microsoft.public.sqlserver.security)
Re: default schema (SQL Server 2005) ...schema (which has always been the default schema for sysadmins, ... schema for this role "dbo" and our application has been writtem not to ... I agree with the statement that a sysadmin works with in teh database ... so how can I provide user access via an application ... (microsoft.public.sqlserver.security)
Re: default schema (SQL Server 2005) ... A sysadmin works within databases in the dbo context, so it will use the dbo ...schema (which has always been the default schema for sysadmins, ... (microsoft.public.sqlserver.security)
Re: Alter User for domain user ... while still having a default non-dbo schema.... If you are sysadmin, you are ...dbo in the database, and your default schema is dbo. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (microsoft.public.sqlserver.security)
RE: 2000 to 2003 domain controller upgrade ... |Subject: RE: 2000 to 2003 domain controller upgrade... Produced By Microsoft MimeOLE V5.50.4910.0300 ... |>|the Schema FSMO role.... |>|>|which I would like the schema master role transferred.... (microsoft.public.windows.server.migration)
