Permision and Users Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

I have a SQL Serevr 2000 DB and using MS SQL 2005 Management Studio to
connect.

We have a domain called WDM and have setup users Fred, Betty and Sam all
part of the group Web Designers. I have allowed them access to the db and
assigned them as the dbo.

The problem is when we create a table or view the tables name is
WDM\Fred.myTable. We then need to use sp_changeobjectowner to change the
owner, but then all permissions are lost!

I need to configure MS SQL 2005 Management Studio to on defualt use the dbo
to crate objects. For example on default create dbo.myTable and not use my
Windows Login details.

I use Windows Authentication in Mixed mode. The only work around is we
loginto the DB using SA.

Can I setup Management Studio to save objects as dbo. and not my user domain
group WDM\Fred.

Thanks Daren


.

Relevant Pages

  • !!!Attention SQL Server 2005 Gurus :: Management Studio problems!!!
    ... I use Management Studio to develop/maintain a SQL Server 2000 database ... What is the equivalent Management Studio action for the following SQL ... SQL Query Analyzer 2000 has an option to "Script object-level ...
    (microsoft.public.sqlserver)
  • Re: Sql Mobil (SqlCE 3.0) and Full Framework
    ... Yes I'm using Sql2005 Management Studio with replication and that is the ... > SQL Mobile database. ... > would on the device *except* you bring in a reference to the desktop ...
    (microsoft.public.sqlserver.ce)
  • Re: Subscription to SQL 2000 from SQLX 2005?
    ... I am using Management Studio Express CTP, ... I'm working in a test environment where our license is for 1 processor, SQL ... least not according to the documentation, which says that SQL Server Express ... > selecting to push the subscription, the create subscription wizard of SQL ...
    (microsoft.public.sqlserver.replication)
  • Re: Best Practices: Ad Hoc Analysis Front end for Sql Server 2005
    ... If you know SQL then Management Studio is the best way. ... Management Studio is a clunky way to do ad hoc analyses. ... is a pain (and, speaking of removing functionality, there's some useful importing capability in SqlServer2000 enterprise manager ... State what version of SQL Server you are using and specify the content ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Full-Text Catalog does not build...
    ... John, thank you. ... from time to time during population I have got event about SQL ... Server machine has 6GB RAM, SQL Server uses AWE and has 5GB memory. ... dbo properties PK_properties 7 1 cat_neu_prop1 ...
    (microsoft.public.sqlserver.fulltext)