Re: dbo Owner

Hi
Add the user to dbo_owner database role. If the user is a member of sysadmin
role so any objects he/she will be created with dbo. prefix. On the other
hand if the user is a member of dbo_owner database role asnd not a sysadmin
,so she/he will need to specify dbo with creation a object
User Alex
---
CREATE TABLE dbo.MyTable (col INT NO NULL)
--
CREATE TABLE MyTable (col INT NO NULL)

I will see Alex.MytTable ( because he does not specify the DBO user name)




"Yap Michael" <yapmichael2000@xxxxxxxxx> wrote in message
news:%238pEs5%23SGHA.5924@xxxxxxxxxxxxxxxxxxxxxxx
Dear All,

How to setting certain user so when they create stored procedure, the
stored procedure belongs to dbo.

Thanks & Regards

Yap Michael


.

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: dbo/owner
    ... 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). ...
    (microsoft.public.sqlserver.security)
  • Re: When creating a new table, owner is DBO I need another user
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Default User
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)