RE: dbo/owner

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 05/25/04

  • Next message: Renato: "win2000 vs msde 7" 
    Date: Tue, 25 May 2004 13:54:24 GMT

    The only way the users can create procedures with dbo as the owner is to be
    a member of the db_owner role (or sysadmin).

    However, you can use the sp_changeobjectowner procedure to change the owner
    of the procedures after they are created. This will require a little more
    administrative effort.

    Rand
    This posting is provided "as is" with no warranties and confers no rights.

  • Next message: Renato: "win2000 vs msde 7"

    Relevant Pages

    • RE: SQL2KSP4 sp_addalias and db_accessadmin
      ... Based on my test, after installing SP4, only member of sysadmin or dbo can ... It seems a design behaviour. ...
      (microsoft.public.sqlserver.security)
    • 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: View Designer Role and Security
      ... Have you tried making the user a member of the db_owner role and when he ... This will make the dbo the owner of the view so you should not have to give ... This posting is provided "as is" with no warranties and confers no rights. ...
      (microsoft.public.sqlserver.security)
    • Re: default object owner
      ... A user needs to be a member of db_owner or db_ddladmin roles ... db_owner and db_ddladmin need to qualify the owner as ... dbo.object when they create the objects to be owned by dbo. ... >It seems not sufficient to be a member of group dbo to make dbo the default owner ...
      (microsoft.public.sqlserver.security)
    • Changing Table Owner and user Owner
      ... and i'm suddenly don't member of Dbo ... What i need to change on the server in order so when i create new object ... after i change that how can i change the owner of tables, ...
      (microsoft.public.sqlserver.security)