Re: Alter User for domain user

In the end, a default schema really isn't that important - to me, anyway.
Why not explicitly schema-qualify everything you create and use? This way,
nothing is left to chance.

My $0.02

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"David Walker" <none@xxxxxxxx> wrote in message
news:Xns9A97A6658C92DavidWalker@xxxxxxxxxxxxxxxx
Erland Sommarskog <esquel@xxxxxxxxxxxxx> wrote in
news:Xns9A98B2B8C6EYazorman@xxxxxxxxx:

David Walker (none@xxxxxxxx) writes:
I see that the IS group, which I am a member of, has the sysadmin
fixed role on the server. Maybe that's the problem.

Yes, as Tom said. This is exactly the heart of the matter. If you
are sysadmin on server level, you are always dbo in the database.

You can easily verify this by running this statement in the database
of your choice:

SELECT USER



Oh, cr*p. I don't WANT to be dbo. But I want access to DO everything,
while still having a default non-dbo schema.

WHY exactly is the default schema ignored for anyone who is a member of
a Windows group that has the sysadmin role? This seems like kind of an
arbitrary thing.

Since my username is defined separately (from the group) in the
database, and in the server, I wish SQL would ignore the fact that I am
also part of a group that has the sysadmin role.

Even if I have the sysadmin role, I should be able to set my default
schema and not have it ignored. I suppose that's an enhancement request
(but it seems arbitrary).

Oh wise one, do you have any insight on that? (I'm serious, not being
sarcastic here...)

Thanks.

David Walker

.

Relevant Pages

  • RE: Inconsistent Schema Versions
    ... on the existing server, to try to force it to upgrade to the same version. ... Microsoft MSDN Online Support Lead ... Subject: Inconsistent Schema Versions ... The schema version of the database ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: Managing a Database using Word / IIS
    ... You then attach the schema to the word document and essentially ... Word doc and insert the data. ... It's a free addition to the Windows Server ... > populated with data from an database, then downloaded to the client PC. ...
    (microsoft.public.office.developer.automation)
  • Re: Alter User for domain user
    ... are sysadmin on server level, you are always dbo in the database. ... You can easily verify this by running this statement in the database ... while still having a default non-dbo schema. ... also part of a group that has the sysadmin role. ...
    (microsoft.public.sqlserver.security)
  • Re: adprep /forestprep failure
    ... I ran ntdsutil to seize the schema master role, ... # Jorge de Almeida Pinto # MVP Windows Server - Directory Services ... The win 2003 server is not yet a DC, since I can't run adprep. ... Schema FSMO holder shows spserver01.season.com. ...
    (microsoft.public.windows.server.active_directory)
  • Re: DB architecture
    ... The new database is replacing a legacy system ... > data) and the rest was moved periodically to an iseries IBM server. ... > we need to change the underlying schema). ... Normalization is no longer required, ...
    (microsoft.public.sqlserver.server)