Re: Not using SA - Then what?

From: Chris Beardsley (clb39@nospam-cornell.edu)
Date: 05/31/02 

From: "Chris Beardsley" <clb39@nospam-cornell.edu>
Date: Fri, 31 May 2002 10:01:31 -0400

> Those creating objects should qualify the object owner with
> dbo when they create it - e.g.
> CREATE TABLE dbo.SomeTable...
For each object? this would be difficult for some to remember...

> If a user logs into SQL Server using windows authentication,
> no user/password is sent - the network login credentials are
> used to authenticate a user.
I knew the NT login. But wouldn't any object those people create be owned by
their NT login?

TIA Chris

Relevant Pages

  • Re: Not using SA - Then what?
    ... If a user logs into SQL Server using windows authentication, ... >have multiple developers/managers login to enterprise manager etc but have ... >all the objects owned by dbo? ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Try not to say "If sa is THE dbo", it's like saying "If I am the joe". ... might help to either say "If sa is the database owner" or, ... The login 'sa' could be listed in sysdatabases as the database ... FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: ASP 2.0, C#, LDAP Login, and Forms impersonation?
    ... Or, I could just start over with a windows authentication login, and after ... FormsAuthenticationTicket fat = fi.Ticket; ... I do not set any dwFlags. ...
    (microsoft.public.dotnet.framework.aspnet.security)