Re: Not using SA - Then what?

From: Richard Waymire [MS] (rwaymi_ms@microsoft.com)
Date: 05/31/02 

From: "Richard Waymire [MS]" <rwaymi_ms@microsoft.com>
Date: Fri, 31 May 2002 12:37:15 -0700

in 6.5 you "aliased" users to the dbo user - so as far as SQL Server was
concerned you are dbo. This feature is still in the product but depricated. 

--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:16iffug02nrp0o9a27hnu98p8p9592eb2b@4ax.com...
> This misconception with db_owners happens a lot - even
> though there is the example in books online with the user
> who is a member of db_owners.
> I've always wondered - was there something in 6.5 where it
> worked differently or where multiple users could be mapped
> to dbo?
>
> -Sue
>
> On Fri, 31 May 2002 11:48:15 -0700, "Richard Waymire [MS]"
> <rwaymi_ms@microsoft.com> wrote:
>
> >Actually this isn't quite correct.  The users CAN create objects as
> >dbo.objectname but it won't happen by default.  Only the one and only dbo
> >user will have that happen by default.
>

Relevant Pages

  • Re: Granting GRANT permissions
    ... How do I allow a user to create a stored procedure for 'dbo' without giving ... that errors out saying you can't use AS when granting those rights. ... > can grant permissions on their own procedures to other users. ...
    (microsoft.public.sqlserver.security)
  • Re: Granting GRANT permissions
    ... not DBO, but you can act as the owner of the object. ... > that errors out saying you can't use AS when granting those rights. ... >> Creators of stored procedures (standard users with CREATE PROCEDURE ... >> procedure and then grant permissions on it to another user B ...
    (microsoft.public.sqlserver.security)
  • User rights problem
    ... "Specified owner name 'dbo' either does not exist or you do not have ... rights which i should give to the "developer" login for donig so. ...
    (microsoft.public.sqlserver.security)
  • Re: Setting Table Permissions?
    ... > Empty - Revoked ... > By default a user has no rights to an object unless they are dbo or in a ... > role that has rights. ... >> everythign with an X where I don't want user access, ...
    (microsoft.public.sqlserver.security)
  • Re: Installing a 360 Media Center Extender
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.windows.mediacenter)