Home Forums SQL Server 2008 Security (SS2K8) Table designer using new DOMAIN\User schema instead of dbo when creating new tables RE: Table designer using new DOMAIN\User schema instead of dbo when creating new tables

  • Are there any diffs between the privilege or permission_path when you run this against each principal?

    EXEC sys.xp_logininfo

    @acctname = 'domain\user1',

    @option = 'all';

    EXEC sys.xp_logininfo

    @acctname = 'domain\user2',

    @option = 'all';

    EXEC sys.xp_logininfo

    @acctname = 'domain\user3',

    @option = 'all';

    EXEC sys.xp_logininfo

    @acctname = 'domain\group',

    @option = 'all';

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato