Re: Default User

Paul (nothanks@xxxxxxxxxxxxxxx) writes:
What do I need to configure to make the sql tables and stored procedures I
create, be dbo owned, rather than owned by my id.

I can change the owner in each wizard, or create code, but I usually
forget and have to re do it.

Which version of SQL Server are you on? If you are on SQL 2000, the
only way out is to make yourself the database owner. On SQL 2005, you
can use ALTER USER to change your default schema.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Granting EXEC for read only SPs
    ... Then, I created a database user, added it to the role 'X' to inherit the ... as the procedure and the accessed tables has the same owner. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: User names
    ... > With SP3 will tables created by upsizing from access also be dbo owned as ... >>dbo by default. ... byjust specifically giving the owner name in QA. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Copy Database Wizard - what would you improve?
    ... "Import and Export Wizard"? ... Another option is Generate Scripts to get the objects. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: Orphan Indexes?
    ... >> Perhaps an owner issue for the table? ... >> Tibor Karaszi, SQL Server MVP ... >>> table is not the same as when I created the SP's in Query Analyzer. ... But now I have a major problem. ...
    (microsoft.public.sqlserver.programming)
  • Re: What is Your Strategy for Upgrade an Access db to SQL Server 2000?
    ... use the wizard", did key word search for it to no avail. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)