Re: Alter User for domain user

"Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx> wrote in
news:#eim$F8rIHA.2292@xxxxxxxxxxxxxxxxxxxx:

What roles do you have? Are you a member of the sysadmin fixed server
role. IIRC, that would make your default schema dbo.


I kept myself as a member of the sysadmin fixed role, since I want those
permissions. I removed myself from the dbo role.

I have changed my default schema away from the dbo schema to something
else, but it's being ignored.

I don't see where it's documented that a member of the sysadmin fixed
server role can't have another default schema (other than dbo) and have it
work.


David Walker
.

Relevant Pages

  • 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: Permission to Users under DB
    ... public and db_owners database roles. ... The user mapped to dbo ... as being a member of db_owners role although the default ... permissions in the database will be the same. ...
    (microsoft.public.sqlserver.security)
  • Re: Access 2007, SQL 2000
    ... Since users are not dbo, and SQL 2000 used the user name as the schema identifier, you have to make sure that every reference to a SQL Server object is fully qualified with the dbo. ... Normally a user should not be able to create any new objects in the db, but if they do, those new objects will be in the userName schema, not the dbo schema, assuming the user is not a db owner. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: exporting into a SQL Server schema
    ... inside of the schema. ... The thing that's most confusing is that the dbo schema isn't ... take a look at the way the objects in the AdventureWorks database are ... It turns out that I'm moving some tables to a web hosted solution with sql ...
    (microsoft.public.access.externaldata)
  • Re: Database connection issue using SQL schema user account
    ... They can simplify permissions insofar as being able to have ... new objects created inside of a schema inherit permissions assigned to ... --The dbo user account is not the same thing as the dbo default ... The dbo user maps to db_owner/sysadmin. ...
    (microsoft.public.dotnet.framework.adonet)