Re: Alter User for domain user

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: 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)
  • Re: Need help on how to organize users and objects
    ... I could assign a custom database role to them though. ... In 2005, if a user creates an sp, which schema does it belong to? ... Security is a huge subject in SQL Server 2005, so I'd suggest you to spend ... the sysadmin; developers and viewers. ...
    (microsoft.public.sqlserver.security)
  • Re: Urgent:deny all users to access the database on another server
    ... multi-database server. ... Dbo must have similar rights within the database. ... > protect schema by using mdw but SQL Server not... ... >>> I deny all the permissions from public users but dbo has ...
    (microsoft.public.sqlserver.security)