Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1500
  • Last Modified:

SQL 2005 dbo owner on tables

I am logging in as

ausername (sa permissions)

Then I am creating tables and they default to owner dbo.  I tried

Use datbasename

exec sp_changeDBOwner owner

created the tables but it is still creating the tables with 'dbo'  any idea?
0
yanci1179
Asked:
yanci1179
  • 2
1 Solution
 
gigglickCommented:
when you create the tables create them as user.table(my columns).  

If you just do table(columns) and you have sa permissions it will always defualt to dbo.table
0
 
yanci1179Author Commented:
can i change the permissions so the default goes to the user name?  What permissions should I use?  I need to create database, tables, updates, inserts, deletes, into the created objects.
0
 
gigglickCommented:
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now