>- see footer for list info -< Allan,
I think have managed to do what you are trying, I created a user and moved a table from one schema to another (dbo.Table to MyUSer.Table). If this is what you are trying to do, I'll write it up the step by step tonight and send it over. Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allan Cliff Sent: 20 April 2007 16:20 To: Coldfusion Development Subject: RE: [CF-Dev] OT: SQL 2005 >- see footer for list info -< Can you do a bit of a step by step thingy, so i can get it right. I have a db with 1 table. I add a new user to the sql server and assign it to this db in question. In server roles i assign every permission. In user mapping i assign it to the db again. In the database security I have also assigned everything to that user. When i try and change the owner using EXEC sp_changeobjectowner 'mytable', 'myuser'; I get: Database principal or schema 'myuser' does not exist in this database. Any ideas? I am really shooting in the dark cos i don't really understand which schema to use and how they are working. Thanks Allan Gene Brown <[EMAIL PROTECTED]> wrote: >- see footer for list info -< Yeah it does, but then my users don't tend to own anything, the most I have to do is grant execute on the SP's and UDF's. Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 20 April 2007 15:47 To: 'Coldfusion Development' Subject: RE: [CF-Dev] OT: SQL 2005 >- see footer for list info -< Wouldn't deleting that schema also remove all info about what objects that user owned ? Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gene Brown Sent: 20 April 2007 14:10 To: Coldfusion Development Subject: RE: [CF-Dev] OT: SQL 2005 >- see footer for list info -< Russ, I had this very issue this morning, in SQL 2k5 users have a schema atatched, quite by accident I found if I deleted the schema (Database, Secuirty, Schema) for the user in the imported database I was then able to delete the user (Database, Security, user), creating the new login and assigning the user access to the newly imported database. Cheers Gene -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Snake Sent: 20 April 2007 13:43 To: 'Coldfusion Development' Subject: RE: [CF-Dev] OT: SQL 2005 >- see footer for list info -< I have similar problems when importing an SQL2000 database into SQL2005, the usual methods for syncing the dbuser with the SQL login do not work either, so the database will not work from CF as the login fails. Considering the same stored procs exist in SQL2005 I dunno why they don't work anymore. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allan Cliff Sent: 20 April 2007 09:16 To: Coldfusion Development Subject: [CF-Dev] OT: SQL 2005 >- see footer for list info -< Does anyone know how to change the owner of a table in SQL 2005 (developer edition)? In SQL 2000 it was very simple, i would just create the new login, then assign it as the dbowner of that database, and I would run sp_changeobjectowner against each table. No luck with 2005 though. Thanks Allan --------------------------------- Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for your freeaccount today. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< --------------------------------- Yahoo! Answers - Got a question? Someone out there knows the answer. Tryit now. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
